Home » RDBMS Server » Server Utilities » Error using parfile (Oracle 11.2.0. , Linux)
Error using parfile [message #592876] Mon, 12 August 2013 16:19 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi,

When i try to run datapump export using parfile, i get following errors.

ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
ORA-31617: unable to open dump file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp" for write
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 20:12:20

FYI

The command that i used is expdp parfile=expdp.par

Here is the content of parfile.
userid=system/pwd
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=schema_expdp%U.dmp
LOGFILE=schema_expdp.log
FILESIZE=4G
COMPRESSION=ALL
PARALLEL=4
CONTENT=ALL
SCHEMAS=schema
CONSISTENT=Y

Schema size is 20 MB

Parfile name is parfile=expdp.par is created under /home/oracle directory

I ran the parfile under /home/oracle directory.

Pls help me to fix this error.

Thanks
Re: Error using parfile [message #592879 is a reply to message #592876] Mon, 12 August 2013 17:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Oracle reports that the file /u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp does not exist.
I trust Oracle to accurately report reality.

What results when you issue OS commands below

id
ls -l /u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp
ls -ld /u01/app/oracle/product/11.2.0/DB1/rdbms/log/
ls -ld /u01/app/oracle/product/11.2.0/DB1/rdbms/
ls -ld /u01/app/oracle/product/11.2.0/DB1/
ls -ld /u01/app/oracle/product/11.2.0/
ls -ld /u01/app/oracle/product/
ls -ld /u01/app/oracle/
ls -ld /u01/app/
ls -ld /u01/


COPY the results from above then PASTE all back here
Re: Error using parfile [message #592894 is a reply to message #592879] Tue, 13 August 2013 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... and check the space in the "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/" file system.

Another point, why do you store your dump in a directory named "rdbms/log/"?

Regards
Michel

Re: Error using parfile [message #593050 is a reply to message #592879] Tue, 13 August 2013 13:37 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi Swan,

Please find the result of the below os commands.

[oracle@RAC2 log]$ id
uid=39811(oracle) gid=76200(oinstall) groups=70036(asmdba),76000(dba),76200(oinstall)


[oracle@RAC2 log]$ ls -l /u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp
ls: /u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp: No such file or directory

[oracle@RAC2 log]$ ls -ld /u01/app/oracle/product/11.2.0/DB1/rdbms/log/
drwxr-xr-x 2 oracle oinstall 12288 Aug 12 21:59 /u01/app/oracle/product/11.2.0/DB1/rdbms/log/

[oracle@RAC2 log]$ ls -ld /u01/app/oracle/product/11.2.0/DB1/rdbms/
drwxr-xr-x 13 oracle oinstall 4096 May 23  2012 /u01/app/oracle/product/11.2.0/DB1/rdbms/


[oracle@RAC2 log]$ ls -ld /u01/app/oracle/product/11.2.0/DB1/
drwxr-xr-x 75 oracle oinstall 4096 Aug 13 08:00 /u01/app/oracle/product/11.2.0/DB1/

[oracle@RAC2 log]$ ls -ld /u01/app/oracle/product/11.2.0/
drwxrwxr-x 4 oracle oinstall 4096 Oct  8  2012 /u01/app/oracle/product/11.2.0/

[oracle@RAC2 log]$ ls -ld /u01/app/oracle/product/
drwxrwxr-x 6 oracle oinstall 4096 Apr 27 18:53 /u01/app/oracle/product/


[oracle@RAC2 log]$ ls -ld /u01/app/oracle/
drwxr-xr-x 12 oracle oinstall 4096 May 30 04:38 /u01/app/oracle/


[oracle@RAC2 log]$ ls -ld /u01/app/
drwxr-xr-x 6 root oinstall 4096 May 23  2012 /u01/app/


[oracle@RAC2 log]$ ls -ld /u01/
drwxr-xr-x 5 root oinstall 4096 Jul 10 17:52 /u01/
Re: Error using parfile [message #593053 is a reply to message #592894] Tue, 13 August 2013 13:41 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi Michel,

Quote:
check the space in the "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/" file system.

[oracle@RAC2 log]$ du -h /u01/app/oracle/product/11.2.0/DB1/rdbms/log
4.1G /u01/app/oracle/product/11.2.0/DB1/rdbms/log

Quote:
Another point, why do you store your dump in a directory named "rdbms/log/"?

Because DATA_PUMP_DIR directory points to "/u01/app/oracle/product/11.2.0/DB1/rdbms/log"

Thanks
Re: Error using parfile [message #593054 is a reply to message #593053] Tue, 13 August 2013 13:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ I meant the free space
2/ This is an error but you will see it sooner or later

Regards
Michel
Re: Error using parfile [message #593056 is a reply to message #593054] Tue, 13 August 2013 13:55 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

Could you tell me how to find the free space of a "/u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/log/" directory?
Re: Error using parfile [message #593057 is a reply to message #593056] Tue, 13 August 2013 15:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
df -ml /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/log


Regards
Michel
Re: Error using parfile [message #593059 is a reply to message #593057] Tue, 13 August 2013 15:32 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

sorry . there is small confusion. DATA_PUMP_DIR directory points to "/u01/app/oracle/product/11.2.0/DB1/rdbms/log" directory and not to /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/log directory.

[oracle@RAC02 log]$ df -ml /u01/app/oracle/product/11.2.0/DB1/rdbms/log
Filesystem           1M-blocks      Used Available Use% Mounted on
/dev/mapper/applvg-u01lv
                        200579     76759    113632  41% /u01

Re: Error using parfile [message #593092 is a reply to message #593059] Wed, 14 August 2013 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now:
ps -eaf | grep pmon | grep $ORACLE_SID
id

Regards
Michel

[Updated on: Wed, 14 August 2013 00:51]

Report message to a moderator

Re: Error using parfile [message #593208 is a reply to message #593092] Thu, 15 August 2013 01:35 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
[oracle@RAC02 ~]$ ps -eaf | grep pmon | grep $ORACLE_SID
grid     13440     1  0 Jul10 ?        00:19:43 asm_pmon_+ASM2
[oracle@RAC02 ~]$
[oracle@RAC02 ~]$
[oracle@RAC02 ~]$ echo $ORACLE_SID
+ASM2
[oracle@RAC02 ~]$ id
uid=39811(oracle) gid=76200(oinstall) groups=70036(asmdba),76000(dba),76200(oinstall)
Re: Error using parfile [message #593210 is a reply to message #593208] Thu, 15 August 2013 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If your ORACLE_SID is on ASM instance you cannot (and it is meaningless to) use expdp.

Regards
Michel
Re: Error using parfile [message #593213 is a reply to message #593210] Thu, 15 August 2013 02:37 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
No.if i set ORACLE_SID to DB sid also i cannot use expdp.
Re: Error using parfile [message #593219 is a reply to message #593213] Thu, 15 August 2013 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How can we help you if you don't post what you actually do?

Regards
Michel
Re: Error using parfile [message #593276 is a reply to message #593219] Thu, 15 August 2013 08:37 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

What i am trying to say is even after setting ORACLE_SID=SID_NAME , i am getting same error .

Regards
Suhasdba
Re: Error using parfile [message #593278 is a reply to message #593276] Thu, 15 August 2013 08:45 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Just telling us what you're doing isn't much use. You need to open a command window and repeat the process you are getting until you get the behaviour you have been experiencing. Then, COPY and PASTE the whole session (from start to finish) into one post.
Re: Error using parfile [message #593280 is a reply to message #593278] Thu, 15 August 2013 09:00 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel/gazzag,

Here is the output.

[oracle@RAC02 ~]$ expdp parfile=expdp.par

Export: Release 11.2.0.3.0 - Production on Thu Aug 15 13:52:28 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "consistent=TRUE" Location: Parameter File, Replaced with: "flashback_time=TO_TIMESTAMP('2013-08-15 13:52:28', 'YYYY-MM-DD HH24:MI:SS')"
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_06":  system/******** parfile=expdp.par reuse_dumpfiles=true
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.43 MB
. . exported "BG"."WSI_REQUEST"                      71.39 KB    1388 rows
. . exported "BG"."BULK_REGISTRATION_CONFIG"         5.742 KB       8 rows
. . exported "BG"."ENROLMENT_STATE"                  5.226 KB       0 rows
Processing object type SCHEMA_EXPORT/USER
. . exported "BG"."GFC_REQUEST_DATA"                 559.8 KB   82594 rows
. . exported "BG"."MBANKING_SMS_PROPERTIES"          5.304 KB       8 rows
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
. . exported "BG"."SEQUENCE"                         4.804 KB       3 rows
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
. . exported "BG"."USSDGW_MESSAGE"                   6.601 KB      56 rows
. . exported "BG"."USSD_PROMPT"                      941.3 KB   31668 rows
. . exported "BG"."USSDGW_MSGTEMPLATE"               5.523 KB      46 rows
. . exported "BG"."USSDGW_MSGTEMPLATEFIELD"          12.09 KB     734 rows
. . exported "BG"."USSDGW_PROP"                        5.5 KB      21 rows
. . exported "BG"."USSD_MSGCONTENTMAPPING"           8.101 KB     260 rows
. . exported "BG"."USSD_SERVICE"                     5.031 KB       3 rows
. . exported "BG"."WSI_INTERCEPTOR_PROPERTY"         5.382 KB      19 rows
. . exported "BG"."XMLSMS_PROPERTY"                  5.992 KB      39 rows
. . exported "BG"."XMLSMS_TRANSLATION"               8.570 KB      56 rows
. . exported "BG"."XMLSMS_XPATH_EXPR"                7.117 KB     102 rows
. . exported "BG"."BULK_FILE_DETAIL"                     0 KB       0 rows
. . exported "BG"."BULK_FILE_RECORDS"                    0 KB       0 rows
. . exported "BG"."BULK_RECORD_DATA"                     0 KB       0 rows
. . exported "BG"."USSDGW_PUSHMESSAGE"                   0 KB       0 rows
. . exported "BG"."USSD_USERSESSION"                     0 KB       0 rows
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_06" failed to load/unload
ORA-31617: unable to open dump file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp" for write
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/DB1/rdbms/log/schema_expdp04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Job "SYSTEM"."SYS_EXPORT_SCHEMA_06" stopped due to fatal error at 13:53:18

[oracle@RAC02 ~]$
[oracle@sl73usircd02 ~]$ ps -eaf | grep pmon | grep $ORACLE_SID
oracle    5634     1  0 Jul28 ?        00:10:59 ora_pmon_DB2

Re: Error using parfile [message #593282 is a reply to message #593280] Thu, 15 August 2013 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results of following OS command

ls -ltr /u01/app/oracle/product/11.2.0/DB1/rdbms/log/


please post URL to Oracle documentation where CONSISTENT can be used by expdp

[Updated on: Thu, 15 August 2013 09:12]

Report message to a moderator

Re: Error using parfile [message #593291 is a reply to message #593280] Thu, 15 August 2013 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Here is the output.


You MUST post all what we asked you in a SINGLE session.
In addition, is /u01... a mounted FS or a "local" one?

Regards
Michel
Re: Error using parfile [message #593326 is a reply to message #593282] Thu, 15 August 2013 12:03 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Swan,

Here is the results of OS commands.

[oracle@RAC02 ~]$ ls -ltr /u01/app/oracle/product/11.2.0/DB1/rdbms/log/
total 4218708
-rw-r----- 1 oracle asmadmin   7639040 Dec  3  2012 03122012_DEPLOYMENT_1.dmp
-rw-r----- 1 oracle asmadmin   2326528 Dec  3  2012 expdat.dmp
-rw-r----- 1 oracle asmadmin  17371136 Dec 13  2012 13122012_HK.dmp
-rw-r--r-- 1 oracle asmadmin      2017 Dec 23  2012 ORCL1_121223_2218.log
-rw-r----- 1 oracle asmadmin    335872 Dec 23  2012 ORCL2_DB_121223_2218.dmp
-rw-r--r-- 1 oracle asmadmin      1674 Dec 29  2012 ORCL5_demo_121229_1719.log
-rw-r----- 1 oracle asmadmin    225280 Dec 29  2012 ORCL5_demo_121229_1719.dmp
-rw-r--r-- 1 oracle asmadmin      1272 Jan  3  2013 ORCL5_PRD_130103_2332.log
-rw-r----- 1 oracle asmadmin    167936 Jan  3  2013 ORCL5_PRD_130103_2332.dmp
-rw-r----- 1 oracle asmadmin  29257728 Feb 22 07:14 ORCL3_BG_02_22_2013.dmp
-rw-r--r-- 1 oracle oinstall  18644992 Feb 22 07:35 bak_18_09_2012.dmp
-rw-r--r-- 1 oracle asmadmin     15934 Feb 22 07:57 bak22_18_09_2012.log
-rw-r--r-- 1 oracle asmadmin     16240 Feb 22 13:17 ORCL3_bg_db_02_22_2013.log
-rw-r----- 1 oracle asmadmin  18599936 Feb 22 13:17 ORCL3_bg_DB_02_22_2013.dmp
-rw-r--r-- 1 oracle asmadmin      2469 Feb 22 13:20 ORCL3_pf_db_02_22_2013.log
-rw-r----- 1 oracle asmadmin    499712 Feb 22 13:20 ORCL3_pf_DB_02_22_2013.dmp
-rw-r----- 1 oracle asmadmin  29032448 Feb 24 22:01 hau22_20_10_2012.dmp
-rw-r--r-- 1 oracle oinstall       333 Feb 24 22:11 ORCL3_BG_PRD_25022013.log
-rw-r--r-- 1 oracle asmadmin     34563 Feb 24 22:19 BG_20_10_2012.log
-rw-r--r-- 1 oracle asmadmin     63992 Feb 24 22:32 BG_prd_20_10_2012.log
-rw-r----- 1 oracle asmadmin  28962816 Feb 25 05:19 ORCL3_BG_02_25_2013.dmp
-rw-r--r-- 1 oracle asmadmin     16299 Feb 25 05:19 ORCL3_02_25_2013.log
-rw-r----- 1 oracle oinstall     32768 Feb 26 23:30 ORCL6_ORCL4_27022013_N.dmp
-rw-r--r-- 1 oracle oinstall       597 Feb 26 23:36 ORCL3_ORCL4_27022013.log
-rw-r--r-- 1 oracle oinstall   3166208 Feb 27 07:55 ORCL3_ORCL4_02_27_2013.dmp
-rw-r--r-- 1 oracle oinstall      2968 Feb 27 21:34 ORCL3_ORCL4_28022013.log
-rw-r--r-- 1 oracle asmadmin     16277 Mar 30 04:25 ORCL3_brandgroup_db.log
--rw-r--r-- 1 oracle asmadmin     16475 Jun 18 11:50 ORCL3_BG_DB_06_18_2013.log
-rw-r----- 1 oracle asmadmin    208896 Aug 13 22:06 ORCL4_expdp03.dmp
-rw-r----- 1 oracle asmadmin   1544192 Aug 13 22:06 ORCL4_expdp02.dmp
-rw-r----- 1 oracle asmadmin    139264 Aug 13 22:06 ORCL4_expdp01.dmp
-rw-r----- 1 oracle asmadmin   1884160 Aug 15 13:28 ORCL4_expdpBalaji.dmp
-rw-r--r-- 1 oracle asmadmin      4152 Aug 15 13:28 ORCL4_expdpBalaji.log
-rw-r----- 1 oracle asmadmin      4096 Aug 15 13:53 schema_expdp04.dmp
-rw-r--r-- 1 oracle asmadmin      4140 Aug 15 13:53 schema_expdp.log
-rw-r----- 1 oracle asmadmin    139264 Aug 15 13:53 schema_expdp03.dmp
-rw-r----- 1 oracle asmadmin    208896 Aug 15 13:53 schema_expdp02.dmp
-rw-r----- 1 oracle asmadmin   1544192 Aug 15 13:53 schema_expdp01.dmp



Quote:
please post URL to Oracle documentation where CONSISTENT can be used by expdp


i dont know how to post that URL to Oracle documentation.We could use CONSISTENT parameter and this is possible since 11.2.

Regards,
Re: Error using parfile [message #593327 is a reply to message #593326] Thu, 15 August 2013 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
expdp help=yes does NOT show CONSISTENT as be a valid option
what happens if you remove it from the control file.

[oracle@localhost ~]$ expdp help=yes

Export: Release 11.2.0.2.0 - Production on Thu Aug 15 10:05:38 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


The Data Pump export utility provides a mechanism for transferring data objects
between Oracle databases. The utility is invoked with the following command:

   Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

You can control how Export runs by entering the 'expdp' command followed
by various parameters. To specify parameters, you use keywords:

   Format:  expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
   Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott
               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

------------------------------------------------------------------------------

The available keywords and their descriptions follow. Default values are listed within square brackets.

ATTACH
Attach to an existing job.
For example, ATTACH=job_name.

CLUSTER
Utilize cluster resources and distribute workers across the Oracle RAC.
Valid keyword values are: [Y] and N.

COMPRESSION
Reduce the size of a dump file.
Valid keyword values are: ALL, DATA_ONLY, [METADATA_ONLY] and NONE.

CONTENT
Specifies data to unload.
Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY.

DATA_OPTIONS
Data layer option flags.
Valid keyword values are: XML_CLOBS.

DIRECTORY
Directory object to be used for dump and log files.

DUMPFILE
Specify list of destination dump file names [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.

ENCRYPTION
Encrypt part or all of a dump file.
Valid keyword values are: ALL, DATA_ONLY, ENCRYPTED_COLUMNS_ONLY, METADATA_ONLY and NONE.

ENCRYPTION_ALGORITHM
Specify how encryption should be done.
Valid keyword values are: [AES128], AES192 and AES256.

ENCRYPTION_MODE
Method of generating encryption key.
Valid keyword values are: DUAL, PASSWORD and [TRANSPARENT].

ENCRYPTION_PASSWORD
Password key for creating encrypted data within a dump file.

ESTIMATE
Calculate job estimates.
Valid keyword values are: [BLOCKS] and STATISTICS.

ESTIMATE_ONLY
Calculate job estimates without performing the export.

EXCLUDE
Exclude specific object types.
For example, EXCLUDE=SCHEMA:"='HR'".

FILESIZE
Specify the size of each dump file in units of bytes.

FLASHBACK_SCN
SCN used to reset session snapshot.

FLASHBACK_TIME
Time used to find the closest corresponding SCN value.

FULL
Export entire database [N].

HELP
Display Help messages [N].

INCLUDE
Include specific object types.
For example, INCLUDE=TABLE_DATA.

JOB_NAME
Name of export job to create.

LOGFILE
Specify log file name [export.log].

NETWORK_LINK
Name of remote database link to the source system.

NOLOGFILE
Do not write log file [N].

PARALLEL
Change the number of active workers for current job.

PARFILE
Specify parameter file name.

QUERY
Predicate clause used to export a subset of a table.
For example, QUERY=employees:"WHERE department_id > 10".

REMAP_DATA
Specify a data conversion function.
For example, REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO.

REUSE_DUMPFILES
Overwrite destination dump file if it exists [N].

SAMPLE
Percentage of data to be exported. 

SCHEMAS
List of schemas to export [login schema].

SERVICE_NAME
Name of an active Service and associated resource group to constrain Oracle RAC resources.

SOURCE_EDITION
Edition to be used for extracting metadata.

STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.

TABLES
Identifies a list of tables to export.
For example, TABLES=HR.EMPLOYEES,SH.SALES:SALES_1995.

TABLESPACES
Identifies a list of tablespaces to export.

TRANSPORTABLE
Specify whether transportable method can be used.
Valid keyword values are: ALWAYS and [NEVER].

TRANSPORT_FULL_CHECK
Verify storage segments of all tables [N].

TRANSPORT_TABLESPACES
List of tablespaces from which metadata will be unloaded.

VERSION
Version of objects to export.
Valid keyword values are: [COMPATIBLE], LATEST or any valid database version.

------------------------------------------------------------------------------

The following commands are valid while in interactive mode.
Note: abbreviations are allowed.

ADD_FILE
Add dumpfile to dumpfile set.

CONTINUE_CLIENT
Return to logging mode. Job will be restarted if idle.

EXIT_CLIENT
Quit client session and leave job running.

FILESIZE
Default filesize (bytes) for subsequent ADD_FILE commands.

HELP
Summarize interactive commands.

KILL_JOB
Detach and delete job.

PARALLEL
Change the number of active workers for current job.

REUSE_DUMPFILES
Overwrite destination dump file if it exists [N]. 

START_JOB
Start or resume current job.
Valid keyword values are: SKIP_CURRENT.

STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.

STOP_JOB
Orderly shutdown of job execution and exits the client.
Valid keyword values are: IMMEDIATE.


[oracle@localhost ~]$ 


Re: Error using parfile [message #593330 is a reply to message #593326] Thu, 15 August 2013 12:14 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

Quote:
In addition, is /u01... a mounted FS or a "local" one?

locally mounted File System

[Updated on: Thu, 15 August 2013 12:37]

Report message to a moderator

Re: Error using parfile [message #593342 is a reply to message #593327] Thu, 15 August 2013 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@BlackSwan

Oracle added in 11.2.0.3 CONSISTENT=Y as an equivalent for FLASHBACK_TIME=SYSTIMESTAMP or FLASHBACK_SCN=DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER().
Old habits are hard to break.

Regards
Michel

Re: Error using parfile [message #593369 is a reply to message #593342] Thu, 15 August 2013 23:15 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

I hope i answered your question.Could you respond to that ?

Regards
Suhas

[Updated on: Thu, 15 August 2013 23:24]

Report message to a moderator

Re: Error using parfile [message #593384 is a reply to message #593369] Fri, 16 August 2013 01:20 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know.
The image I have of what you have from what you posted may not be the reality.

Regards
Michel

[Updated on: Fri, 16 August 2013 01:20]

Report message to a moderator

Previous Topic: import only certain number of rows in oracle
Next Topic: Syntax error in using query parameter in expdp
Goto Forum:
  


Current Time: Thu Mar 28 13:43:49 CDT 2024