exp-小写字母表导出问题?

简介: exp 小写字母表

建立小写字母表?

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.
相关文章
|
2月前
|
SQL
sql语句将数字格式修改为字符
sql语句将数字格式修改为字符
|
5月前
|
数据挖掘 数据处理 索引
python str.extract提取小数+表inner内连接后,行数多于之前
python str.extract提取小数+表inner内连接后,行数多于之前
39 0
python str.extract提取小数+表inner内连接后,行数多于之前
|
Oracle 关系型数据库 OLAP
imp-导入小写字母表问题
1建立测试表“emp_bak" 使用双引号建立的表,默认为小写字母的表. SQL> create table "emp_bak" as select * from emp; Table created.
1176 0
|
SQL 数据库
SQL去除数据库表中tab、空格、回车符等特殊字符的解决方法
原文:SQL去除数据库表中tab、空格、回车符等特殊字符的解决方法 按照ASCII码, SELECT char(64) 例如64 对应 @,则 SELECT REPLACE('abc@qq.
3594 0
|
关系型数据库 Oracle 索引
|
关系型数据库 Oracle Linux