RE: Extensions for export files

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 19 Nov 2009 11:48:00 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112E982CE2_at_ONEWS06.oneneck.corp>

Confirmed - test case below:

SYS_at_demo>conn system
Enter password:
Connected.
SYSTEM_at_demo>create table testtab (c number);

Table created.

SYSTEM_at_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_at_demo>drop table testtab;

Table dropped.

SYSTEM_at_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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 19 2009 - 12:48:00 CST