首页 > 数据库 > 数据库开发技术 > 使用exp导出小写表名的方法(from pub)
参见:http://www.itpub.net/viewthread.php?tid=928112&pid=9443577&page=2&extra=
test case on windows:
create table "t_tst_lower_case" as select * from dba_objects a where rownum < 10;
edit a par file
#parfile.txt
tables=('"t_tst_lower_case"')
--注意格式是 单引号+双引号
then run
exp test/test file=test.dmp parfile=parfile.txt
C:>exp test/test file=test.dmp parfile=parfile.txt
Export: Release 9.2.0.4.0 - Production on Thu Jan 17 19:14:45 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in ZHS16GBK 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 t_tst_lower_case 9 rows exported
Export terminated successfully without warnings.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7425608/viewspace-997652/ ,如需转载,请注明出处,否则将追究法律责任。