建立小写字母表?
SQL> create table "test01" as select * from test;
Table created.
SQL> create table "test02" as select * from test;
Table created.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TEST TABLE
test01 TABLE
test02 TABLE
如何导出表?
[oracle@prod04 ~]$ exp t/t file=t.dmp tables="('\"test01\"','\"test02\"')"
Export: Release 11.2.0.4.0 - Production on Thu Jan 10 14:53:52 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table test01 86289 rows exported
. . exporting table test02 86288 rows exported
Export terminated successfully without warnings.
报错信息?
[oracle@prod04 ~]$ exp t/t file=t.dmp tables="(test01,test02)"
Export: Release 11.2.0.4.0 - Production on Thu Jan 10 14:54:04 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
EXP-00011: T.TEST01 does not exist
EXP-00011: T.TEST02 does not exist
Export terminated successfully with warnings.