ITPub博客

首页 > 数据库 > 数据库开发技术 > 使用exp导出小写表名的方法(from pub)

使用exp导出小写表名的方法(from pub)

原创 数据库开发技术 作者:realji 时间:2008-01-18 08:31:52 0 删除 编辑

参见: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.

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7425608/viewspace-997652/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-09

  • 博文量
    55
  • 访问量
    153683