RE: Extensions for export files
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "cemail_219@xxxxxxxxxxx" <cemail_219@xxxxxxxxxxx>, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Nov 2009 11:48:00 -0700
Confirmed - test case below:
SYS@demo>conn system
Enter password:
Connected.
SYSTEM@demo>create table testtab (c number);
Table created.
SYSTEM@demo>quit
Disconnected from Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ux04.oracle ->exp system tables=testtab file=myfile_without_dmp_extension.foo
log=mylog_without_log_extension.foo
Export: Release 10.2.0.4.0 - Production on Thu Nov 19 11:45:15 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TESTTAB 0 rows exported
Export terminated successfully without warnings.
ux04.oracle ->ls -lrt|tail -2
-rw-r--r-- 1 oracle oinstall 399 Nov 19 11:45 mylog_without_log_extension.foo
-rw-r--r-- 1 oracle oinstall 16384 Nov 19 11:45 myfile_without_dmp_extension.foo
ux04.oracle ->sqlplus system
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 19 11:45:35 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
SYSTEM@demo>drop table testtab;
Table dropped.
SYSTEM@demo>exit
Disconnected from Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ux04.oracle ->imp system tables=testtab file=myfile_without_dmp_extension.foo
log=mylog_without_log_extension.foo
Import: Release 10.2.0.4.0 - Production on Thu Nov 19 11:46:12 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. importing SYSTEM's objects into SYSTEM
. . importing table "TESTTAB" 0 rows imported
Import terminated successfully without warnings.
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
