Oracle Database Commands and Practical Examples: EXPDP

Showing posts with label EXPDP. Show all posts

Monday 7 February 2022

Impdp Example using remap_schema and remap_tablespace parameter

Impdp using remap_schema and remap_tablespace parameter

Keywords:

remap_schema: source_schema:destination_schema and remap_tablespace =source_tablespace:target_tablespace

Scenario :

We have done impdp into different schema level to different user without specifying remap_tablespace parameter and face error below

Error:

ORA-39083: Object type TABLE:"TCMANAGER"."ASSIGNME_1773957227_113294481" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Scenario without tablespace

oracle@PLM12:~/expdp> impdp \"sys/sys@PLM12 as sysdba\" directory=expdp dumpfile=expdp-manager2021-09-28_14-36-23.dmp remap_schema=TCPRODMANAGER:TCMANAGER logfile=impdp_tcmanager.log parallel=2

Import: Release 12.1.0.2.0 - Production on Tue Sep 28 14:45:43 2021

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYS"."SYS_IMPORT_FULL_01": "sys/********@PLM12 AS SYSDBA" directory=expdp dumpfile=expdp-manager2021-09-28_14-36-23.dmp remap_schema=TCPRODMANAGER:TCMANAGER logfile=impdp_tcmanager.log parallel=2

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"TCMANAGER" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

ORA-39083: Object type TABLESPACE_QUOTA:"TCMANAGER" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "TCMANAGER" QUOTA 209715200 ON "TCPRODMANAGER"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''TCPRODMANAGER'' AND CONTENTS = ''TEMPORARY''';

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39083: Object type TABLE:"TCMANAGER"."ASSIGNME_1773957227_113294481" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."ASSIGNME_1773957227_113294481" ("ESESSION_ID" NVARCHAR2(128) NOT NULL ENABLE, "POOL_ID" NVARCHAR2(64) NOT NULL ENABLE, "SERVER" NVARCHAR2(128) NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 214748

ORA-39083: Object type TABLE:"TCMANAGER"."POOLS_1773957227_1093459165" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."POOLS_1773957227_1093459165" ("POOL_ID" NVARCHAR2(64) NOT NULL ENABLE, "MANAGER_URI" NVARCHAR2(255) NOT NULL ENABLE, "MUX_URI" NVARCHAR2(255) NOT NULL ENABLE, "NUM_ASSIGNED" NUMBER(10,0) NOT NULL ENABLE, "USE_PERC" FLOAT(126) NOT NULL ENABLE, "LAST_LOGIN" NUMBER(19,0), "CPU_LOAD" NUMBER(10,0)) SEGMENT CREATION IMMED

ORA-39083: Object type TABLE:"TCMANAGER"."CLUSTERC_1773957227_385776844" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."CLUSTERC_1773957227_385776844" ("ID" NUMBER(10,0) NOT NULL ENABLE, "PROCESS_MAX_PER_USER" NUMBER(10,0) NOT NULL ENABLE, "HARD_TIMEOUT_EDIT" NUMBER(10,0) NOT NULL ENABLE, "QUERY_TIMEOUT" NUMBER(10,0) NOT NULL ENABLE, "HARD_TIMEOUT_READ" NUMBER(10,0) NOT NULL ENABLE, "SOFT_TIMEOUT_EDIT" NUMBER(10,0) NOT NULL ENABLE,

ORA-39083: Object type TABLE:"TCMANAGER"."POOLCON_1773957227_2046161837" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."POOLCON_1773957227_2046161837" ("POOL_ID" NVARCHAR2(64) NOT NULL ENABLE, "HOSTNAME" NVARCHAR2(64) NOT NULL ENABLE, "MANAGER_CREATION_TIME" NUMBER(19,0), "ENABLE_CPU_LIMIT_CHECK" NUMBER(10,0) NOT NULL ENABLE, "LOGINS_PER_MINUTE" NUMBER(10,0) NOT NULL ENABLE, "MAX_CPU_LOAD" NUMBER(10,0) NOT NULL ENABLE, "JMX_HTTP_AD

ORA-39083: Object type TABLE:"TCMANAGER"."SERVERS_1773957227_1743233923" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."SERVERS_1773957227_1743233923" ("SERVER" NVARCHAR2(128) NOT NULL ENABLE, "POOL_ID" NVARCHAR2(64) NOT NULL ENABLE, "CREATION_TIME" NUMBER(19,0) NOT NULL ENABLE, "PIPE" NVARCHAR2(128) NOT NULL ENABLE, "SYS_LOG" NVARCHAR2(512) NOT NULL ENABLE, "PID" NUMBER(10,0) NOT NULL ENABLE, "ASGN" NVARCHAR2(512)) SEGMENT CREATIO

ORA-39083: Object type TABLE:"TCMANAGER"."USERSASS_1773957227_428210791" failed to create with error:

ORA-00959: tablespace 'TCPRODMANAGER' does not exist

Failing sql is:

CREATE TABLE "TCMANAGER"."USERSASS_1773957227_428210791" ("ESESSION_ID" NVARCHAR2(128) NOT NULL ENABLE, "USER_ID" NVARCHAR2(64) NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TCPRODMANAGER"

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035955" skipped, base object type TABLE:"TCMANAGER"."ASSIGNME_1773957227_113294481" creation failed

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035956" skipped, base object type TABLE:"TCMANAGER"."POOLS_1773957227_1093459165" creation failed

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035952" skipped, base object type TABLE:"TCMANAGER"."CLUSTERC_1773957227_385776844" creation failed

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035954" skipped, base object type TABLE:"TCMANAGER"."POOLCON_1773957227_2046161837" creation failed

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035953" skipped, base object type TABLE:"TCMANAGER"."SERVERS_1773957227_1743233923" creation failed

ORA-39112: Dependent object type CONSTRAINT:"TCMANAGER"."SYS_C0035951" skipped, base object type TABLE:"TCMANAGER"."USERSASS_1773957227_428210791" creation failed

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SYS"."SYS_IMPORT_FULL_01" completed with 14 error(s) at Tue Sep 28 14:45:55 2021 elapsed 0 00:00:12

Impdp with specifying remap_schema: source_schema:destination_schema and remap_tablespace =source_tablespace:target_tablespace

oracle@PLM12:~/expdp> impdp \"sys/sys@PLM12 as sysdba\" directory=expdp dumpfile=expdp-manager2021-09-28_14-36-23.dmp remap_schema=TCPRODMANAGER:TCMANAGER remap_tablespace=TCPRODMANAGER:TCMANAGER logfile=impdp_tcmanager.log parallel=2

Import: Release 12.1.0.2.0 - Production on Tue Sep 28 14:59:49 2021

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"TCMANAGER" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "TCMANAGER"."SERVERS_1773957227_1743233923" 91.78 KB 238 rows

. . imported "TCMANAGER"."ASSIGNME_1773957227_113294481" 36.10 KB 172 rows

. . imported "TCMANAGER"."CLUSTERC_1773957227_385776844" 10.41 KB 1 rows

. . imported "TCMANAGER"."POOLCON_1773957227_2046161837" 8.562 KB 2 rows

. . imported "TCMANAGER"."POOLS_1773957227_1093459165" 8.195 KB 2 rows

. . imported "TCMANAGER"."USERSASS_1773957227_428210791" 0 KB 0 rows

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Tue Sep 28 14:59:54 2021 elapsed 0 00:00:04

oracle@PLM12:~/expdp>

Thursday 10 December 2020

IMPDP Error : RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037

Scenario Preview :

Recently we faced an error during impdp operation migration of multiple schema from standalone database to 2 node RAC database. We face some issue on some of the tables of particular schemas but . Same script used for standalone DB were working fine also other schema of using same expdp dumpfile.

Reason was instead using TAF services that we have registered. We were doing impdp on particular instance services level.

Error: ORA-31693 | ORA-31640 | ORA-19505

Scenario Error:

After troubleshooting we found we were using parallel option parallel=3 during import

ORA-31693: Table data object "INFODBA"."PPOM_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Command used during import

oracle@01:/u04/MasterDB/expdp/expdp_smrprod> impdp \"sys/xxx@SMRPROD2 as sysdba\" dumpfile=EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp directory=EXPDPPROD logfile=impdpSMRPRODB-$(date +%Y-%m-%d_%H-%M-%S).log schemas=infodba JOB_NAME=FULL_EXPDP_SMRPRODB parallel=3

Import: Release 12.1.0.2.0 - Production on Sun Nov 8 09:34:11 2020

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

Master table "SYS"."FULL_EXPDP_SMRPRODB" successfully loaded/unloaded

Starting "SYS"."FULL_EXPDP_SMRPRODB": "sys/********@SMRPROD2 AS SYSDBA" dumpfile=EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp directory=EXPDPPROD logfile=impdpSMRPRODB-2020-11-08_09-34-11.log schemas=infodba JOB_NAME=FULL_EXPDP_SMRPRODB parallel=3

Processing object type DATABASE_EXPORT/SCHEMA/USER

ORA-31684: Object type USER:"INFODBA" already exists

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

ORA-31693: Table data object "INFODBA"."PPOM_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-31693: Table data object "INFODBA"."PPOM_APPLICATION_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."POM_BACKPOINTER" 605.0 MB 14101046 rows

. . imported "INFODBA"."PIMANFILE" 266.9 MB 1335204 rows

ORA-31693: Table data object "INFODBA"."POM_RECIPE_TABLE" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-31693: Table data object "INFODBA"."POM_LOCK_KEYS" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PFND0WORKFLOWAUDIT" 855.8 MB 1759632 rows

. . imported "INFODBA"."PPSOCCURRENCE" 147.2 MB 588268 rows

ORA-31693: Table data object "INFODBA"."PIMANRELATION" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PWORKSPACEOBJECT" 256.4 MB 1802823 rows

. . imported "INFODBA"."PFND0GENERALAUDIT" 110.8 MB 491362 rows

ORA-31693: Table data object "INFODBA"."PDATASET" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PEPMTASK" 64.87 MB 331746 rows

. . imported "INFODBA"."PFND0SYNC_CHECKSUMS_3" 66.24 MB 887437 rows

. . imported "INFODBA"."PREF_LIST_0" 30.97 MB 805308 rows

. . imported "INFODBA"."PPROJECT_LIST" 28.16 MB 736249 rows

. . imported "INFODBA"."PFND0SECURITYAUDIT" 25.59 MB 85555 rows

. . imported "INFODBA"."PPROPAGATION_OBJ_LIST" 28.12 MB 729337 rows

. . imported "INFODBA"."PREVISIONS" 21.79 MB 562331 rows

. . imported "INFODBA"."PREF_NAMES_0" 25.36 MB 805308 rows

. . imported "INFODBA"."PREF_TYPES" 18.68 MB 805308 rows

Import> stop_job

Are you sure you wish to stop this job ([yes]/no): yes

Solution:

DataPump Import With PARALLEL > 1 In RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037 (Doc ID 1173765.1)

Use cluster=N to run the import from a single node of the RAC cluster which has file access.

Run the Data Pump import job with parallel=1 (default)

Monday 5 October 2020

EXPDP - Example and Commands

Scenario Preview:

Hi all these are some expdp and impdp expamples below for various scenarios which is helpful to me. So sharing the same below and it will re-memories for me also.

Create Directory for EXPDP and IMPDP example

create or replace directory smrtestenv_64 as '/u04/MasterDB/expdp/smrtestenv';

Drop talespace with datafiles Examples

SQL 'DROP TABLESPACE TEST INCLUDING CONTENTS AND DATAFILES';

Check number objects exists on schema

select count(*),object_type,status from dba_objects where owner='INFODBA' group by status,object_type;

select count(*),object_type,status from dba_objects where owner='INFODBA2' group by status,object_type;

Check valid invalid objects of schema

select object_type,count(*) from dba_objects where status='INVALID' and owner='MFUNDLIVE' group by object_type;

select object_type,count(*) from dba_objects where status='VALID' and owner='MFUNDLIVE' group by object_type;

Check distinct tablespace other than default tablespace

select distinct tablespace_name from dba_segments where owner='INFODBA_TEST';

Check expdp backup status

select sid, serial#, sofar, totalwork, dp.owner_name, dp.state, dp.job_mode from gv$session_longops sl, gv$datapump_job dp where sl.opname = dp.job_name and sofar != totalwork;

check job name during impdp expdp

select message, time_remaining/3600 hrs from v$session_longops where sofar <> totalwork;

select t.username,t.START_TIME,t.LAST_UPDATE_TIME,t.TIME_REMAINING,t.ELAPSED_SECONDS,

t.opname,t.target_desc,t.sofar,t.totalwork,t.message from V$SESSION_LONGOPS t where/* t.USERNAME = 'user_name' and*/ t.TARGET_DESC = 'EXPORT';

Recompile invalid objects

@?/rdbms/admin/utlrp.sql

set time on

set timi on

exec dbms_stats.gather_schema_stats('INFODBA',cascade => TRUE,estimate_percent => 30);

EXEC DBMS_UTILITY.COMPILE_SCHEMA( schema => 'INFODBA');

Drop Users

drop user INFODBA1,INFODBA cascade;

purge recyclebin;

Undo Retention increase values if expdp | impdp above 500 GB

alter system set undo_retention=2500 scope=both;

Schema DDL Metadata

set heading off

set echo off

set feedback off

set long 999999

spool Check_PERMISSIONS.txt

set long 100000

set pages 200

select dbms_metadata.get_ddl( 'USER','INFODBA' ) from dual;

select dbms_metadata.get_granted_ddl( 'SYSTEM_GRANT', 'INFODBA' ) from dual;

select dbms_metadata.get_granted_ddl( 'OBJECT_GRANT', 'INFODBA' ) from dual;

select dbms_metadata.get_granted_ddl( 'ROLE_GRANT', 'INFODBA' ) from dual;

spool off

set heading on

set feedback on

Kill Session Example

ALTER SYSTEM KILL SESSION 'sid,serial#';

ALTER SYSTEM KILL SESSION '1345,16564';

ALTER SYSTEM KILL SESSION '176,42616' immediate;

expdp - impdp schema example

Single expdp schema

expdp \"sys/system@prod1 as sysdba\" directory=expdp dumpfile=expdp%u.dmp logfile=expdptest.log schemas=infodba1 parallel=2 content=all exclude=statistics parallel=2

Multiple expdp schema with same tablespace

expdp \"sys/system@prod1 as sysdba\" directory=expdp dumpfile=expdp%u.dmp logfile=expdptest.log schemas=infodba1,infodba2 parallel=2 content=all exclude=statistics parallel=2

Same impdp schema

impdp \"sys/system@prod2 as sysdba\" directory=expdp dumpfile=expdp%u.dmp logfile=impdp_remap.log schemas=infodba parallel=2

Impdp With different schema same tablespace (remap_schema=Source_schema:Destination_schema)

impdp \"sys/system@prod2 as sysdba\" directory=expdp dumpfile=expdp%u.dmp logfile=impdp_remap.log remap_schema=infodba:infodba2 parallel=2

impdp from source schema to destination schema example

impdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp.dmp logfile=impdp_remap.log remap_schema=infodba:infodba1 parallel=2

EXPDP Schema using different directories

expdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp01%u.dmp,expdp1:expdp02%u.dmp logfile=expdp:expdp.log schemas=infodba1 exclude=statistics

impdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp01%u.dmp,expdp1:expdp02%u.dmp logfile=expdp1:impdpdp.log schemas=infodba1 parallel=2

impdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp01%u.dmp,expdp1:expdp02%u.dmp logfile=expdp1:impdpdp.log remap_schema=infodba1:infodba parallel=2

EXPDP FILESIZE

full =y

expdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp01%u.dmp,expdp1:expdp02%u.dmp logfile=expdp:expdp.log full=y exclude=statistics filesize=200M parallel=2

expdp filesize using %U

expdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp00%u.dmp,expdp1:expdp01%u.dmp,expdp2:expdp02%u.dmp logfile=expdp:expdp.log schemas=infodba1 exclude=statistics filesize=500M

output result file example:

Dump file set for SYS.SYS_EXPORT_S

C:\VARUN\EXPDP\EXPDP0001.DMP

C:\VARUN\EXPDP1\EXPDP0101.DMP

C:\VARUN\EXPDP2\EXPDP0201.DMP

C:\VARUN\EXPDP\EXPDP0002.DMP

C:\VARUN\EXPDP1\EXPDP0102.DMP

C:\VARUN\EXPDP2\EXPDP0202.DMP

C:\VARUN\EXPDP\EXPDP0003.DMP

C:\VARUN\EXPDP1\EXPDP0103.DMP

Expdp | Impdp remap schema (multiple schema)

expdp \"sys/sys@prod12c as sysdba\" directory=expdp dumpfile=expdp:expdp01%u.dmp,expdp1:expdp02%u.dmp logfile=expdp:expdp.log schemas=infodba1,infodba2 exclude=statistics

Same Tablespace

impdp \"sys/system@smrprodb as sysdba\" dumpfile=expdp:expdp00%u.dmp,expdp1:expdp01%u.dmp,expdp2:expdp02%u.dmp logfile=expdp:impdp.log remap_schema=infodba1:infodba3,infodba2:infodba4 parallel=2 filesize =200m

Different Tablespace

impdp \"sys/sys@smrprodb as sysdba\" dumpfile=expdp:expdp00%u.dmp,expdp1:expdp01%u.dmp,expdp2:expdp02%u.dmp logfile=expdp:impdp.log remap_schema=infodba1:infodba3,infodba2:infodba4 remap_tablespace=idata:idata3,idata:idata4,ilog:ilog4,indx:indx4

EXPDP Using Flashback SCN

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=ful_flashback_scn.dmp logfile=full_flashback_scn.log full=y FLASHBACK_SCN=2106577

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=ful_flashback_scn.dmp logfile=full_flashback_scn.log schemas=infodba flashback_time="to_timestamp('13-12-2017 13:23:00', 'DD-MM-YYYY HH24:MI:SS')"

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=ful_flashback_scn.dmp logfile=full_flashback_scn.log schemas=infodba flashback_time=flashback_time=to_timestamp$sysdate-15/1440$

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=ful_flashback_scn.dmp logfile=full_flashback_scn.log schemas=infodba flashback_time=TO_TIMESTAMP('13-12-2017 13:23:00','DD-MM-YYYY HH24:MI:SS')

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=ful_flashback_scn.dmp logfile=full_flashback_scn.log schemas=infodba FLASHBACK_TIME="2017/12/1315:34:01"

Reuse_dumpfiles

expdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table.log tables=infodba.PITEM,infodba.PAM_TREE parallel=2 reuse_dumpfiles=Y

EXPDP Tables

expdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table.log tables=infodba.PITEM,infodba.PAM_TREE parallel=2

expdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table.log tables=infodba.PITEM,infodba.PAM_TREE,testuser.test_table parallel=2

IMPDP TABLES

impdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log tables=infodba.PITEM:infodbatest.pitem2,infodba.PAM_TREE:infodbatest:pam_tree2 parallel=2

impdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=infodba.PITEM:infodbatest.pitem2,infodba.PAM_TREE:infodbatest:pam_tree2 parallel=2

impdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=PITEM:infodbatest.pitem2,PAM_TREE:infodbatest:pam_tree2 parallel=2

TABLE_EXISTS_ACTION REPLACE| TRUNCATE | APPEND | SKIP

impdp "sys/sys@dmenv AS SYSDBA" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=pitem:pitem2,PAM_TREE:pam_tree2 parallel=2 TABLE_EXISTS_ACTION=REPLACE

impdp \"sys/sys@dmenv AS SYSDBA\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=pitem:pitem2,PAM_TREE:pam_tree2 parallel=2 TABLE_EXISTS_ACTION=REPLACE

impdp \"sys/sys@dmenv AS SYSDBA\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=pitem:pitem2,PAM_TREE:pam_tree2 parallel=2 TABLE_EXISTS_ACTION=truncate

impdp "sys/sys@dmenv AS SYSDBA" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=pitem:pitem2,PAM_TREE:pam_tree2 parallel=2 TABLE_EXISTS_ACTION=REPLACE

impdp \"sys/sys@dmenv AS SYSDBA\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=pitem:pitem2,PAM_TREE:pam_tree2 parallel=2 TABLE_EXISTS_ACTION=replace

impdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log tables=infodba.PITEM,infodba.pam_tree remap_schema=infodba:infodbatest parallel=2 TABLE_EXISTS_ACTION=append

IMPDP different tables same schema

impdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=dmenv_table1.dmp logfile=impdp_dmenv_table1.log tables=PITEM:PITEM2,PFORM:PFORM2

impdp \"sys/sys@dmenv as sysdba\" directory=expdpdmenv dumpfile=expdp_table%u.dmp logfile=impdp_table1.log remap_table=PITEM:pitem2,pam_tree:pam_tree2 remap_schema=infodba:infodbatest parallel=2

ESTIMATE_ONLY

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV ESTIMATE_ONLY=yes logfile=full_log_estimate.log

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV ESTIMATE=y logfile=full_log_estimate.log full=y

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV ESTIMATE=BLOCKS logfile=full_log_estimate.log full=y

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV ESTIMATE=STATISTICS logfile=full_log_estimate.log full=y

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV ESTIMATE_ONLY=y logfile=full_log_estimate.log schemas=infodba

Remap_tablespaces

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=tablesace_dmenv.dmp logfile=tablespace_dmenv.log tablespace=IDATA

imppdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=tablesace_dmenv.dmp logfile=tablespace_dmenv.log remap_tablespaces=IDATA:IDATATEST

Transport_tablespaces

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=transport_tablesace_dmenv.dmp logfile=transport_tablespace_dmenv.log transport_tablespaces=IDATA

expdp \"sys/sys@dmenv as sysdba \" directory=EXPDPDMENV dumpfile=transport_tablesace_dmenv.dmp logfile=transport_tablespace_dmenv.log transport_tablespaces=IDATA,ILOG

RAC Database expdp example

service_name=RAC service name (optional)

cluster=y

expdp \"sys/system123@prodb as sysdba \" directory=expdpu01 dumpfile=SOE12%u.dmp logfile=expdp_soe.log schemas=soe cluster=y service_name=prodb

Monday 23 March 2020

expdp Master Table error ORA-31633:

ERROR :

ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRTESTENV"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object

oracle@s08:~> sh /u02/scripts/expdp_SMRTESTENV_full.sh

Export: Release 12.1.0.2.0 - Production on Mon Mar 23 11:48:20 2020

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRTESTENV"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object

SQL> SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2; 2 3 4

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS
---------------------------------------- ---------------------------------------- ------------------------------ -------------------- ------------------------------ -----------------
SYS FULL_EXPDP_SMRTESTENV EXPORT FULL NOT RUNNING 0

SQL> drop table sys.FULL_EXPDP_SMRTESTENV;

Table dropped.

SQL> SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2; 2 3 4

no rows selected

SQL>

oracle@s08:/u01/app/oracle/diag/rdbms/smrtestenv/SMRTESTENV/trace> sh /u02/scripts/expdp_SMRTESTENV_full.sh

Export: Release 12.1.0.2.0 - Production on Mon Mar 23 12:09:13 2020

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."FULL_EXPDP_SMRTESTENV": "sys/********@SMRTESTENV AS SYSDBA" dumpfile=expdpSMRTESTENV-2020-03-23_12-09-13.dmp directory=EXP_SMRTESTENV logfile=expdpSMRTESTENV-2020-03-23_12-09-13.log FULL=Y EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=FULL_EXPDP_SMRTESTENV parallel=2
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.858 GB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

Monday 11 November 2019

EXPDP -Error - ORA-31626,ORA-31633,ORA-06512, ORA-06512,ORA-00955

DataPump Export Or Import Fails With Errors ORA-31633 ORA-6512 ORA-955 (Doc ID 556425.1)
oracle@sgdcplm02:/u04/MasterDB/scripts> sh expdp_SMRRAC_full.sh

Export: Release 12.1.0.2.0 - Production on Fri Oct 25 12:40:28 2019

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRRAC1"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object

oracle@sgdcplm02:/u04/MasterDB/scripts> sqlplus sys/system123@smrrac1 as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 25 12:40:38 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d
SP2-0310: unable to open file "d.sql"
SQL> select sid, serial#, sofar, totalwork,
dp.owner_name, dp.state, dp.job_mode
from gv$session_longops sl, gv$datapump_job dp
where sl.opname = dp.job_name and sofar != totalwork; 2 3 4

no rows selected

SQL> SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2; 2

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE ATTACHED_SESSIONS
------------------------------ -----------------
SYS
FULL_EXPDP_SMRRAC1
EXPORT

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE ATTACHED_SESSIONS
------------------------------ -----------------
FULL
NOT RUNNING 0

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE ATTACHED_SESSIONS
------------------------------ -----------------
SYS
FULL_EXPDP_SMRRAC2
EXPORT

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE ATTACHED_SESSIONS
------------------------------ -----------------
FULL
NOT RUNNING 0

SQL> SELECT o.status, o.object_id, o.object_type, o.owner||'.'||object_name "OWNER.OBJECT"
FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2; 2

STATUS OBJECT_ID OBJECT_TYPE
------- ---------- -----------------------
OWNER.OBJECT
--------------------------------------------------------------------------------
VALID 105403 TABLE
SYS.FULL_EXPDP_SMRRAC1

VALID 106260 TABLE
SYS.FULL_EXPDP_SMRRAC2

SQL>

Table dropped.

SQL> drop table SYS.FULL_EXPDP_SMRRAC2;

Table dropped.

SQL> select o.status, o.object_id, o.object_type,

o.owner||'.'||object_name "OWNER.OBJECT"

from dba_objects o, dba_datapump_jobs j

where o.owner=j.owner_name and

o.object_name=j.job_name and

j.job_name not like 'BIN$%'

order by 4, 2; 2 3 4 5 6 7

no rows selected

Wednesday 23 October 2019

expdp - permission error ORA-31693, ORA-31617

EXPDP ERROR Example :

ORA-31693: Table data object "INFODBA"."PPOM_CLASS" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"

ORA-27037: unable to obtain file status

Solution : Check permission and group on expdp directory

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
oracle@sgdcplm02:/u04/MasterDB/expdp/expdp_smrrac>

Export: Release 12.1.0.2.0 - Production on Mon Oct 21 10:09:24 2019

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "SYS"."FULL_EXPDP_SMRRAC1": "sys/********@SM AS SYSDBA" dumpfile=expdp-SMMRAC12019-10-21_10-09-24.dmp directory=EXPDP_SMRRAC logfile=expdpSMRRAC1-2019-10-21_10-09-24.log FULL=Y EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=FULL_EXPDP_SMRRAC1 parallel=2
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 145.2 MB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
. . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows
. . exported "SYS"."AUD$" 0 KB 0 rows
. . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows
. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows
. . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows
. . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows
. . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows
. . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows
. . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows
. . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows
. . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows
. . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows
. . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows
. . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows
. . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows
. . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows
. . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows
. . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows
. . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows
. . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows
. . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows
. . exported "WMSYS"."WM$HINT_TABLE$" 9.453 KB 75 rows
. . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows
. . exported "WMSYS"."WM$REMOVED_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows
. . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows
. . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows
. . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.054 KB 10 rows
. . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POL" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows
. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 8.671 KB 4 rows
ORA-31693: Table data object "SYS"."KU$_USER_MAPPING_VIEW" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:
. . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 10.21 KB 22 rows
. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
. . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows
. . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . exported "SYS"."NACL$_ACE_EXP" 9.929 KB 1 rows
. . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows
. . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows
. . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows
. . exported "INFODBA"."POM_BACKPOINTER" 11.90 MB 277596 rows
. . exported "INFODBA"."PL10N_PROPERTY_NAME" 9.389 MB 112502 rows
. . exported "INFODBA"."PPOM_OBJECT" 10.02 MB 210260 rows
. . exported "INFODBA"."PFND0WORKFLOWAUDIT" 5.835 MB 13871 rows
. . exported "INFODBA"."PDATA" 2.042 MB 3 rows
. . exported "INFODBA"."PL10N_TYPE_NAME" 2.732 MB 30920 rows
. . exported "INFODBA"."PPOM_APPLICATION_OBJECT" 2.827 MB 30747 rows
. . exported "INFODBA"."PDATA_0" 382.1 KB 56 rows
. . exported "INFODBA"."PBUSINESSRULE" 1.993 MB 21736 rows
. . exported "INFODBA"."PFND0GENERALAUDIT" 1.848 MB 8929 rows
. . exported "INFODBA"."PL10N_FND0ENTRY" 2.301 MB 29405 rows
. . exported "INFODBA"."PWORKSPACEOBJECT" 2.216 MB 17615 rows
. . exported "INFODBA"."PARGUMENTS" 1.276 MB 16870 rows
. . exported "INFODBA"."PEPMHANDLER" 992.1 KB 22091 rows
. . exported "INFODBA"."PEPMTASKTEMPLATE" 922.2 KB 6211 rows
. . exported "INFODBA"."PIMANTYPE" 863.7 KB 8222 rows
. . exported "INFODBA"."POPERATION" 870.6 KB 3984 rows
. . exported "INFODBA"."PBODY_TEXT_0" 66.00 KB 13 rows
. . exported "INFODBA"."PFND0PR_SCRIPT" 19.60 KB 7 rows
. . exported "INFODBA"."PEPMTASK" 831.8 KB 4520 rows
. . exported "INFODBA"."PDATATYPEREF" 759.0 KB 18537 rows
. . exported "INFODBA"."PIMANRELATION" 768.5 KB 8154 rows
. . exported "INFODBA"."PACTION_HANDLERS" 674.2 KB 16865 rows
. . exported "INFODBA"."PDATATYPE" 661.8 KB 4398 rows
. . exported "INFODBA"."PEXTENSIONPOINT" 638.0 KB 10691 rows
. . exported "INFODBA"."PPOM_ATTRIBUTE" 608.3 KB 5660 rows
. . exported "INFODBA"."PPROPERTYCONSTANTATTACH" 584.0 KB 9646 rows
. . exported "INFODBA"."PPROPERTYINFO" 574.2 KB 10238 rows
. . exported "INFODBA"."PSTRUCTELEMENT" 590.8 KB 9608 rows
. . exported "INFODBA"."PCONSTANTATTACH" 535.9 KB 16255 rows
. . exported "INFODBA"."POPERATIONTEMPLATE" 535.9 KB 1511 rows
. . exported "INFODBA"."PACTIONS" 433.5 KB 10822 rows
ORA-31693: Table data object "ORDDATA"."ORDDCM_DOCS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."PDESCRIPTION" 416.7 KB 3498 rows
. . exported "INFODBA"."PEXTENSIONPOINTS" 431.4 KB 10691 rows
. . exported "INFODBA"."PFND0MESSAGE" 284.5 KB 1208 rows
. . exported "INFODBA"."PIMANFILE" 455.9 KB 2205 rows
. . exported "INFODBA"."PCONTENTS" 125.8 KB 2988 rows
. . exported "INFODBA"."PEPMBRHANDLER" 123.2 KB 5225 rows
. . exported "INFODBA"."PEPMBUSINESSRULE" 132.0 KB 5032 rows
. . exported "INFODBA"."PEXTENSIONDESCRIPTOR" 116.4 KB 1741 rows
. . exported "INFODBA"."PFND0EVENTTYPEMAPPING" 130.8 KB 1044 rows
. . exported "INFODBA"."PFND0FEATURE_KEYS" 13.68 KB 136 rows
. . exported "INFODBA"."PFND0PRIVATEKEY" 8.820 KB 1 rows
. . exported "INFODBA"."PGENERATEDDATATYPE" 136.7 KB 3283 rows
. . exported "INFODBA"."PL10N_CONDITION_DESC" 122.2 KB 254 rows
. . exported "INFODBA"."PL10N_QUERY_NAME" 103.2 KB 1036 rows
. . exported "INFODBA"."PLISTOFRECEIVERS" 100 KB 2345 rows
. . exported "INFODBA"."PLOV_VALUES_3" 130.7 KB 3735 rows
. . exported "INFODBA"."POPERATIONPARAMETER" 140.6 KB 2550 rows
. . exported "INFODBA"."POPPARAMETERDATATYPEREF" 105.9 KB 2550 rows
. . exported "INFODBA"."PPARAMETERINFO" 108.9 KB 2484 rows
. . exported "INFODBA"."PPARAMETERSINFOS" 104.4 KB 2484 rows
. . exported "INFODBA"."PPARAMETERS_1" 107.0 KB 2550 rows
. . exported "INFODBA"."PPROPERTYBMOPERATION" 112.3 KB 2253 rows
. . exported "INFODBA"."PPROPERTYOPERATION" 98.66 KB 2512 rows
. . exported "INFODBA"."PQUERY_CLAUSES" 118.2 KB 580 rows
. . exported "INFODBA"."PREF_NAMES_0" 141.3 KB 3792 rows
. . exported "INFODBA"."PREF_TYPES" 95.29 KB 3792 rows
. . exported "INFODBA"."PVALIDITY" 133.3 KB 1781 rows
. . exported "INFODBA"."PANCHOR" 46.71 KB 1588 rows
. . exported "INFODBA"."PATTACHMENTS" 75.32 KB 1736 rows
. . exported "INFODBA"."PATTACHMENT_TYPES" 47.77 KB 1736 rows
. . exported "INFODBA"."PCONDITION" 44.23 KB 155 rows
. . exported "INFODBA"."PEXT_DESCRIPTORS" 81.87 KB 1931 rows
. . exported "INFODBA"."PFND0AUDITDEFPROPERTY" 91.14 KB 905 rows
. . exported "INFODBA"."PICM0" 155.4 KB 142 rows
. . exported "INFODBA"."PL10N_QUERY_DESC" 97.68 KB 662 rows
. . exported "INFODBA"."PL10N_RD_DESCRIPTION" 88.66 KB 450 rows
. . exported "INFODBA"."PL10N_RD_NAME" 55.40 KB 455 rows
. . exported "INFODBA"."PLISTOFVALUES" 97.25 KB 761 rows
. . exported "INFODBA"."PLOV_VALUE_DESCRIPTIONS_3" 59.66 KB 1858 rows
. . exported "INFODBA"."PMETAINTERFACE" 46.03 KB 1081 rows
. . exported "INFODBA"."POM_KEY" 82.19 KB 1534 rows
. . exported "INFODBA"."POPERATIONINPUTPROPERTY" 67.48 KB 1477 rows
. . exported "INFODBA"."POPERATIONRETURNDATATYPEREF" 65.39 KB 1511 rows
. . exported "INFODBA"."PPROCESS_STAGE_LIST" 66.60 KB 1519 rows
. . exported "INFODBA"."PRELEASESTATUS" 48.85 KB 620 rows
. . exported "INFODBA"."PREVISIONANCHOR" 44.82 KB 1283 rows
. . exported "INFODBA"."PRUNTIMEPROPERTY" 93.42 KB 1845 rows
. . exported "INFODBA"."PS4_SMRPART" 79.30 KB 508 rows
. . exported "INFODBA"."PSTRUCT" 65.82 KB 2808 rows
. . exported "INFODBA"."PVALID_EVENTTYPES" 45.68 KB 984 rows
. . exported "INFODBA"."ACLS" 7.679 KB 7 rows
. . exported "INFODBA"."EIM_UID_GENERATOR_ROOT" 5.554 KB 1 rows
. . exported "INFODBA"."MFK_WORK_KEYS" 5.968 KB 1 rows
. . exported "INFODBA"."MFK_WORK_OBJS" 5.093 KB 1 rows
. . exported "INFODBA"."PACCESSOR_LIST" 7.445 KB 28 rows
. . exported "INFODBA"."PACTION_LIST" 6.390 KB 1 rows
. . exported "INFODBA"."PALLOWABLE_VIEW_TYPES" 7.218 KB 22 rows
. . exported "INFODBA"."PAM_ACE" 30.75 KB 383 rows
. . exported "INFODBA"."PAM_ACL" 12.01 KB 122 rows
. . exported "INFODBA"."PAM_NAMED_TAG" 6.554 KB 29 rows
. . exported "INFODBA"."PAM_PRIVILEGES" 7.046 KB 34 rows
. . exported "INFODBA"."PAM_TREE" 31.84 KB 222 rows
. . exported "INFODBA"."PAPPDATAMODELDEFINITION" 11.21 KB 142 rows
. . exported "INFODBA"."PAPPEXTENSIONPOINT" 7.296 KB 1 rows
. . exported "INFODBA"."PAPPINTERFACETYPE" 10.62 KB 3 rows
. . exported "INFODBA"."PARCWELDREVISIONMASTER" 6.039 KB 1 rows
. . exported "INFODBA"."PARGUMENTKEYS" 6.234 KB 10 rows
. . exported "INFODBA"."PATTR_CLASSES" 5.968 KB 1 rows
. . exported "INFODBA"."PATTR_NAMES" 5.953 KB 1 rows
. . exported "INFODBA"."PAUDITDEFINITION" 18.50 KB 80 rows
. . exported "INFODBA"."PAUDITLOG" 5.5 KB 1 rows
. . exported "INFODBA"."PAUTHORIZATIONRULE" 7.687 KB 28 rows
. . exported "INFODBA"."PBOM_VIEW_TAGS" 8.421 KB 53 rows
. . exported "INFODBA"."PBUSINESSELEMENT" 11.96 KB 169 rows
. . exported "INFODBA"."PBUSINESSOBJECTINTERFACE" 39.37 KB 948 rows
. . exported "INFODBA"."PCALLBACKFUNCTION" 24.88 KB 199 rows
. . exported "INFODBA"."PCFMLATESTENTRY" 5.546 KB 2 rows
. . exported "INFODBA"."PCFMSTATUSENTRY" 6.648 KB 7 rows
. . exported "INFODBA"."PCFMWORKINGENTRY" 8.039 KB 6 rows
. . exported "INFODBA"."PCHANGEITEM" 15.88 KB 97 rows
. . exported "INFODBA"."PCHANGEITEMREVISION" 13.55 KB 100 rows
. . exported "INFODBA"."PCHANGETYPEDATA" 9.210 KB 3 rows
. . exported "INFODBA"."PCHILD_TASK_TAGLIST_0" 6.523 KB 4 rows
. . exported "INFODBA"."PCLAUSES_0" 5.968 KB 1 rows
. . exported "INFODBA"."PCLIENTDATAMASTER" 6.859 KB 1 rows
. . exported "INFODBA"."PCLOSURERULE" 28.25 KB 288 rows
. . exported "INFODBA"."PCMHASIMPACTEDITEM" 7.140 KB 49 rows
. . exported "INFODBA"."PCOMPONENTRELATION" 5.734 KB 11 rows
. . exported "INFODBA"."PCONDITIONPARAMETER" 16.92 KB 309 rows
. . exported "INFODBA"."PCONDITIONSIGNATURE" 5.617 KB 5 rows
. . exported "INFODBA"."PCONDITION_PARAMETERS" 6.718 KB 9 rows
. . exported "INFODBA"."PCONDITION_SIGNATURES" 6.562 KB 5 rows
. . exported "INFODBA"."PCONSTANT" 35.01 KB 163 rows
. . exported "INFODBA"."PCONSTANTCHOICE" 9.929 KB 123 rows
. . exported "INFODBA"."PCONSTANT_CHOICES" 8.226 KB 47 rows
. . exported "INFODBA"."PCOSTVALUE" 5.992 KB 3 rows
. . exported "INFODBA"."PCOUNTER_TAGS_0" 8.625 KB 58 rows
. . exported "INFODBA"."PCRFQUERYSOURCE" 12.14 KB 52 rows
. . exported "INFODBA"."PDATAFILES" 0 KB 0 rows
. . exported "INFODBA"."PDATAFILESKEYS" 0 KB 0 rows
. . exported "INFODBA"."PDATASETTYPE" 19.47 KB 190 rows
. . exported "INFODBA"."PDATUMPOINTREVISIONMASTER" 6.148 KB 2 rows
. . exported "INFODBA"."PDEEPCOPYRULE" 41.47 KB 350 rows
. . exported "INFODBA"."PDEFAULT_VALUES" 6.226 KB 7 rows
. . exported "INFODBA"."PDEPENDENTON" 10.33 KB 100 rows
. . exported "INFODBA"."PDISPATCHERREQUEST" 13.13 KB 2 rows
. . exported "INFODBA"."PDMTEMPLATEFORM" 10.08 KB 5 rows
. . exported "INFODBA"."PDOCUMENTREVISION" 8.804 KB 128 rows
. . exported "INFODBA"."PDRAWINGVERMASTER" 6.078 KB 23 rows
. . exported "INFODBA"."PDRAWING_0_REVISION_ALT" 5.921 KB 23 rows
. . exported "INFODBA"."PEFFECTIVITYMODE" 5.523 KB 1 rows
. . exported "INFODBA"."PENCRYPTIONKEY" 5.984 KB 1 rows
. . exported "INFODBA"."PENTRY_LIST" 7.101 KB 19 rows
. . exported "INFODBA"."PENVELOPE" 23.19 KB 263 rows
. . exported "INFODBA"."PEPMJOB" 41.38 KB 347 rows
. . exported "INFODBA"."PEPMSIGNOFFPROFILE" 8.968 KB 13 rows
. . exported "INFODBA"."PEVENTTYPEMAPPING" 10.20 KB 79 rows
. . exported "INFODBA"."PEVENTTYPE_DESCRIPTORS" 29.88 KB 984 rows
. . exported "INFODBA"."PEXCELTEMPLATE" 5.789 KB 14 rows
. . exported "INFODBA"."PEXCEL_TEMPLATE_RULES" 6 KB 2 rows
. . exported "INFODBA"."PEXPORTTEMPLATE" 5.882 KB 20 rows
. . exported "INFODBA"."PEXTERNALDATATYPE" 6.601 KB 27 rows
. . exported "INFODBA"."PFILTER" 7.671 KB 10 rows
. . exported "INFODBA"."PFND0AUDITDEFINITION" 35.45 KB 218 rows
. . exported "INFODBA"."PFND0BMIDERESOURCE" 16.71 KB 503 rows
. . exported "INFODBA"."PFND0CLIENTSESSIONINFO" 9.953 KB 30 rows
. . exported "INFODBA"."PFND0DEPLOYVERSION" 5.992 KB 2 rows
. . exported "INFODBA"."PFND0DETAILEDMESSAGE" 36.03 KB 1208 rows
. . exported "INFODBA"."PFND0DETAILEDMESSAGES" 14.46 KB 205 rows
. . exported "INFODBA"."PFND0EXTENSIONS" 11.53 KB 118 rows
. . exported "INFODBA"."PFND0FILTER_ATTRIBUTES" 5.953 KB 1 rows
. . exported "INFODBA"."PFND0ICONRESOURCE" 11.25 KB 310 rows
. . exported "INFODBA"."PFND0LICENSEUSAGE" 30.53 KB 136 rows
. . exported "INFODBA"."PFND0LISTOFVALUESDYNAMIC" 7.492 KB 5 rows
. . exported "INFODBA"."PFND0MAX_VALUE_REASON" 8.539 KB 48 rows
. . exported "INFODBA"."PFND0OBJECTSTATUS" 10.13 KB 113 rows
. . exported "INFODBA"."PFND0PRIVATEKEY_0" 6.437 KB 1 rows
. . exported "INFODBA"."PFND0PROPERTYRENDERER" 7.062 KB 7 rows
. . exported "INFODBA"."PFND0PROPERTYRENDERERATTACH" 7.843 KB 7 rows
. . exported "INFODBA"."PFND0QUERY_CLAUSE" 6.375 KB 5 rows
. . exported "INFODBA"."PFND0RESOURCES" 10.76 KB 113 rows
. . exported "INFODBA"."PFOLDER" 29.71 KB 932 rows
. . exported "INFODBA"."PFORMTYPEDEF" 23.39 KB 459 rows
. . exported "INFODBA"."PFORM_TYPES" 6.671 KB 8 rows
. . exported "INFODBA"."PFRI_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PFULLTEXT" 8.460 KB 13 rows
. . exported "INFODBA"."PFUNCTIONALITYRULE" 12.49 KB 124 rows
. . exported "INFODBA"."PGDETYPEDEFINITION" 6.507 KB 22 rows
. . exported "INFODBA"."PGLOBALCONSTANT" 7.664 KB 49 rows
. . exported "INFODBA"."PGLOBALCONSTANTATTACH" 6.515 KB 23 rows
. . exported "INFODBA"."PGNCHANGEREQUESTREVISION" 6.187 KB 37 rows
. . exported "INFODBA"."PGROUP" 16.17 KB 128 rows
. . exported "INFODBA"."PGROUPMEMBER" 19.91 KB 319 rows
. . exported "INFODBA"."PGROUPSECURITYNAMEDTAG" 5.546 KB 2 rows
. . exported "INFODBA"."PHASPARTICIPANT" 20.78 KB 775 rows
. . exported "INFODBA"."PHISTORYDATES" 5.945 KB 1 rows
. . exported "INFODBA"."PHISTORYSTATES" 5.945 KB 1 rows
. . exported "INFODBA"."PIMANACTIONHANDLER" 10.48 KB 11 rows
. . exported "INFODBA"."PIMANCOMPOUNDPROPDEF" 20.41 KB 153 rows
. . exported "INFODBA"."PIMANEVENTTYPE" 13.89 KB 138 rows
. . exported "INFODBA"."PIMANGRM" 42.86 KB 380 rows
. . exported "INFODBA"."PIMANIDCREATOR" 7.453 KB 6 rows
. . exported "INFODBA"."PIMANNEXTID" 12.65 KB 193 rows
. . exported "INFODBA"."PIMANPARAMETERS" 6.468 KB 45 rows
. . exported "INFODBA"."PIMANPFF" 8.492 KB 14 rows
. . exported "INFODBA"."PIMANQUERY" 35.39 KB 246 rows
. . exported "INFODBA"."PIMANRESERVATION" 18.00 KB 33 rows
. . exported "INFODBA"."PIMANSUBSCRIPTION" 16.47 KB 6 rows
. . exported "INFODBA"."PIMANVOLUME" 11.34 KB 2 rows
. . exported "INFODBA"."PIMSPROFILE" 6.914 KB 6 rows
. . exported "INFODBA"."PINFO" 21.51 KB 560 rows
. . exported "INFODBA"."PINPUTS" 6.476 KB 3 rows
. . exported "INFODBA"."PINPUT_FORMATS" 7.710 KB 67 rows
. . exported "INFODBA"."PINSTALLEDTEMPLATES" 8.179 KB 9 rows
. . exported "INFODBA"."PIRDC" 19.11 KB 40 rows
. . exported "INFODBA"."PITEMMASTER" 8.109 KB 2 rows
. . exported "INFODBA"."PITEMVERSIONMASTER" 8.320 KB 13 rows
. . exported "INFODBA"."PKEY" 6.140 KB 10 rows
. . exported "INFODBA"."PL10N_ACL_NAME" 17.85 KB 122 rows
. . exported "INFODBA"."PL10N_NAME" 20.63 KB 158 rows
. . exported "INFODBA"."PL10N_NAME_0" 10.42 KB 39 rows
. . exported "INFODBA"."PL10N_NAME_1" 39.75 KB 365 rows
. . exported "INFODBA"."PL10N_NAME_2" 26.90 KB 235 rows
. . exported "INFODBA"."PL10N_NAME_3" 11.88 KB 54 rows
. . exported "INFODBA"."PL10N_ROLE_NAME" 20.17 KB 145 rows
. . exported "INFODBA"."PL10N_TASKTYPE_NAME" 17.59 KB 122 rows
. . exported "INFODBA"."PL10N_TCCAL_NAME" 9.304 KB 21 rows
. . exported "INFODBA"."PLIBRARY" 23.32 KB 122 rows
. . exported "INFODBA"."PLISTOFVALUESCHAR" 6.828 KB 1 rows
. . exported "INFODBA"."PLISTOFVALUESINTEGER" 8.914 KB 85 rows
. . exported "INFODBA"."PLISTOFVALUESSTRING" 23.71 KB 660 rows
. . exported "INFODBA"."PLISTOFVALUESTAG" 7.25 KB 10 rows
. . exported "INFODBA"."PLIST_OF_ROLE" 21.83 KB 389 rows
. . exported "INFODBA"."PLIST_OF_TOOLS" 19.94 KB 344 rows
. . exported "INFODBA"."PLIST_OF_TOOLS_VIEW" 20.03 KB 346 rows
. . exported "INFODBA"."PLOV_ATTACHED_CONDITIONS" 28.26 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_PROPERTIES" 26.15 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_SPECIFIERS" 18.78 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_TYPES" 27.14 KB 552 rows
. . exported "INFODBA"."PLOV_VALUES" 6.054 KB 6 rows
. . exported "INFODBA"."PLOV_VALUES_2" 20.09 KB 579 rows
. . exported "INFODBA"."PLOV_VALUE_DESCRIPTIONS_2" 20.49 KB 469 rows
. . exported "INFODBA"."PLOV_VALUE_INDEXES" 28.46 KB 925 rows
. . exported "INFODBA"."PMANAGED_OBJECTS" 6.875 KB 13 rows
. . exported "INFODBA"."PMEACTIVITY" 17.51 KB 75 rows
. . exported "INFODBA"."PMEOPREVISION" 9.304 KB 75 rows
. . exported "INFODBA"."PMEPROCESS" 0 KB 0 rows
. . exported "INFODBA"."PMEPROCESSMASTER" 8.460 KB 75 rows
. . exported "INFODBA"."PMEPROCESSVERSIONMASTER" 8.476 KB 75 rows
. . exported "INFODBA"."PMETAENUM" 7.343 KB 86 rows
. . exported "INFODBA"."PMETAENUMLITERAL" 23.41 KB 457 rows
. . exported "INFODBA"."PMETAENUMLITERALS" 23.65 KB 434 rows
. . exported "INFODBA"."PMEWORKAREA" 0 KB 0 rows
. . exported "INFODBA"."PMFG0BVRTOOLREQUIREMENT" 0 KB 0 rows
. . exported "INFODBA"."PMFG0MEEQUIPMENTREVISION" 0 KB 0 rows
. . exported "INFODBA"."PMFG0PROCAREATWPLOCATIONREL" 0 KB 0 rows
. . exported "INFODBA"."PMON_RANGES" 6.75 KB 10 rows
. . exported "INFODBA"."PM_PROCESS_LIST" 9.843 KB 57 rows
. . exported "INFODBA"."PNAMECOUNTER" 12.46 KB 58 rows
. . exported "INFODBA"."PNAMEFIELD" 10.13 KB 38 rows
. . exported "INFODBA"."PNAMERULE" 7.460 KB 36 rows
. . exported "INFODBA"."PNAMERULEPATTERN" 10.07 KB 82 rows
. . exported "INFODBA"."PNAME_PATTERNS" 9.601 KB 82 rows
. . exported "INFODBA"."PNOTETYPE" 9.257 KB 42 rows
. . exported "INFODBA"."PNXAGENTREVISION" 6.039 KB 2 rows
. . exported "INFODBA"."POBJECT_HIERARCHY" 20.62 KB 341 rows
. . exported "INFODBA"."POFFICEDOCDATA" 9.875 KB 3 rows
. . exported "INFODBA"."POM_BOOT" 6.843 KB 37 rows
. . exported "INFODBA"."POM_B_LOCK" 0 KB 0 rows
. . exported "INFODBA"."POM_F_LOCK" 8.140 KB 80 rows
. . exported "INFODBA"."POM_INDEXES" 28.22 KB 342 rows
. . exported "INFODBA"."POM_LOCK_LOGGING" 0 KB 0 rows
. . exported "INFODBA"."POM_M_LOCK" 7.968 KB 14 rows
. . exported "INFODBA"."POM_ROOT" 10.41 KB 1 rows
. . exported "INFODBA"."POM_R_LOCK" 9.070 KB 42 rows
. . exported "INFODBA"."POM_TIMESTAMP" 8.234 KB 43 rows
. . exported "INFODBA"."POPERATIONATTACH" 35.76 KB 559 rows
. . exported "INFODBA"."POPTION_DESCRIPTIONS" 19.90 KB 198 rows
. . exported "INFODBA"."POPTION_DISPLAYNAMES" 15.5 KB 198 rows
. . exported "INFODBA"."POPTION_GROUPNAMES" 13.23 KB 198 rows
. . exported "INFODBA"."POPTION_INITIALVALUES" 11.35 KB 198 rows
. . exported "INFODBA"."POPTION_READONLYFLAGS" 10.60 KB 198 rows
. . exported "INFODBA"."POPTION_REALNAMES" 13.33 KB 198 rows
. . exported "INFODBA"."POUTPUTS" 6.390 KB 1 rows
. . exported "INFODBA"."POUTPUT_FORMATS" 7.718 KB 67 rows
. . exported "INFODBA"."POVERRIDE_LOV_ATTACHMENTS" 18.67 KB 552 rows
. . exported "INFODBA"."PPARAMETERS" 19.57 KB 261 rows
. . exported "INFODBA"."PPARAMETERS_0" 18.21 KB 300 rows
. . exported "INFODBA"."PPARENT" 5.937 KB 1 rows
. . exported "INFODBA"."PPARTICIPANT" 9.375 KB 93 rows
. . exported "INFODBA"."PPARTMASTER" 16.40 KB 507 rows
. . exported "INFODBA"."PPARTVERMASTER" 16.27 KB 525 rows
. . exported "INFODBA"."PPERSON" 15.58 KB 74 rows
. . exported "INFODBA"."PPFF_CLAUSES" 13.78 KB 40 rows
. . exported "INFODBA"."PPIEACTIONRULE" 7.773 KB 1 rows
ORA-31693: Table data object "INFODBA"."PDATASET" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPROJECTOBJECTRELATION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PSTRUCTELEMENTS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PTYPECONSTANTATTACH" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PCLAUSES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PDEPENDENCY_TASK_TEMPLATES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PEPMACTION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPARAMS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPROJECT_LIST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPROPAGATION_OBJ_LIST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPROPERTY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PFND0LOVDICTIONARYENTRY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PFND0SECURITYAUDIT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."POM_RECIPE_TABLE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPROJECT_LIST_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PRULES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PRULE_HANDLERS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PDEPENDENCY_TASK_ACTIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PEXTENSION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PFND0DETAIL" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PFORM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PHIDETYPERULE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PITEM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PITEMREVISION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PL10N_FND0EVENTTYPE_NAME" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PLOV_VALUE_CONDITIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PPOM_CLASS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PREF_LIST_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PREVISIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PARGUMENTDATA" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PBMOPERATION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PCLAUSES_1" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."PPLMAPPUID" 26.38 KB 177 rows
. . exported "INFODBA"."PPOM_ACCESSOR" 35.00 KB 507 rows
. . exported "INFODBA"."PPOM_APPLICATION" 7.257 KB 9 rows
. . exported "INFODBA"."PPOM_CATIAMODELATTRIBUTES" 15.83 KB 1 rows
. . exported "INFODBA"."PPOM_CATIA_DOC_ATTR_FORM" 6.867 KB 1 rows
. . exported "INFODBA"."PPOM_GROUP" 15.64 KB 128 rows
. . exported "INFODBA"."PPOM_IMC" 9.875 KB 1 rows
. . exported "INFODBA"."PPOM_MEMBER" 27.48 KB 319 rows
. . exported "INFODBA"."PPOM_SESSION" 7.562 KB 14 rows
. . exported "INFODBA"."PPOM_SITE_CONFIG" 6.023 KB 3 rows
. . exported "INFODBA"."PPOM_USER" 22.26 KB 73 rows
. . exported "INFODBA"."PPRIMARYOBJECTS" 6.398 KB 1 rows
. . exported "INFODBA"."PPROCESSES" 6 KB 3 rows
. . exported "INFODBA"."PPROJECTPREFERENCE" 6.859 KB 1 rows
. . exported "INFODBA"."PPROJECTTEAM" 6.617 KB 52 rows
. . exported "INFODBA"."PPROJECT_MEMBERS" 13.47 KB 179 rows
. . exported "INFODBA"."PPROPERTIES" 7.125 KB 38 rows
. . exported "INFODBA"."PPROPERTIES_0" 5.953 KB 1 rows
. . exported "INFODBA"."PPROPERTYCONSTANT" 7.078 KB 18 rows
. . exported "INFODBA"."PPROPERTYSET" 11.89 KB 64 rows
. . exported "INFODBA"."PPSBOMVIEW" 10.83 KB 53 rows
. . exported "INFODBA"."PPSBOMVIEWREVISION" 9.031 KB 17 rows
. . exported "INFODBA"."PPSOCCURRENCE" 50.92 KB 101 rows
. . exported "INFODBA"."PPSOCCURRENCETHREAD" 8.859 KB 101 rows
. . exported "INFODBA"."PPSOCCURRENCETYPE" 6.617 KB 20 rows
. . exported "INFODBA"."PPSVIEWTYPE" 7.007 KB 6 rows
. . exported "INFODBA"."PRANGE" 7.789 KB 71 rows
. . exported "INFODBA"."PRBFEXPRESSION" 5.570 KB 3 rows
. . exported "INFODBA"."PRBFINPUT" 5.992 KB 3 rows
. . exported "INFODBA"."PRBFOUTPUT" 5.523 KB 1 rows
. . exported "INFODBA"."PRBFPARAMDEF" 6.992 KB 4 rows
. . exported "INFODBA"."PRD_PARAMETERS" 13.22 KB 219 rows
. . exported "INFODBA"."PRD_PARAM_VALUES" 13.28 KB 219 rows
. . exported "INFODBA"."PRD_STYLE_SHEETS" 12.25 KB 149 rows
. . exported "INFODBA"."PRELATIONPROPERTY" 35.89 KB 421 rows
. . exported "INFODBA"."PRELATION_TYPE_LIST" 6.601 KB 6 rows
. . exported "INFODBA"."PRELEASE" 11.50 KB 37 rows
. . exported "INFODBA"."PRELEASE_STATUS_LIST" 31.18 KB 635 rows
. . exported "INFODBA"."PREPORTDEFINITION" 32.65 KB 80 rows
. . exported "INFODBA"."PREPORTDESIGN" 11.67 KB 23 rows
. . exported "INFODBA"."PREPORT_FORMATTERS" 8.625 KB 57 rows
. . exported "INFODBA"."PRESOURCEPOOL" 10.18 KB 51 rows
. . exported "INFODBA"."PREVISIONRULE" 10.22 KB 11 rows
. . exported "INFODBA"."PROLE" 10.44 KB 65 rows
. . exported "INFODBA"."PROLEINOWNINGGROUP" 8.343 KB 65 rows
. . exported "INFODBA"."PROLEINPROJECTSOFOBJECT" 8.351 KB 65 rows
. . exported "INFODBA"."PROLEINSCHEDULE" 6.039 KB 3 rows
. . exported "INFODBA"."PS4GBLSTDPRTREQFORMSTORAGE" 13.64 KB 31 rows
. . exported "INFODBA"."PS4PCASPARTNUMBERFORMSTORAGE" 17.45 KB 25 rows
. . exported "INFODBA"."PS4REGLSTDPRTREQFORMSTORAGE" 13.17 KB 3 rows
. . exported "INFODBA"."PS4_ADJECTIVES" 5.968 KB 2 rows
. . exported "INFODBA"."PS4_ADJECTIVES_1" 6.304 KB 13 rows
. . exported "INFODBA"."PS4_ASSEMBLIESLH" 9.5 KB 141 rows
. . exported "INFODBA"."PS4_ASSEMBLIESRH" 7.140 KB 48 rows
. . exported "INFODBA"."PS4_CAEITEM" 8.140 KB 1 rows
. . exported "INFODBA"."PS4_CAEITEMREVISION" 5.523 KB 1 rows
. . exported "INFODBA"."PS4_CHANGENOTICEREVISION" 9.601 KB 34 rows
. . exported "INFODBA"."PS4_CHANGEREQUEST" 6.164 KB 35 rows
. . exported "INFODBA"."PS4_CHANGEREQUESTREVISION" 12.26 KB 37 rows
. . exported "INFODBA"."PS4_CHANGEVERIFYREVISION" 9.398 KB 23 rows
. . exported "INFODBA"."PS4_ELECTRICALCOMPONENTSLH" 6.023 KB 3 rows
. . exported "INFODBA"."PS4_ELECTRICALCOMPONENTSRH" 6.070 KB 5 rows
. . exported "INFODBA"."PS4_ENGGCOSTFORMSTORAGE" 24.11 KB 60 rows
. . exported "INFODBA"."PS4_FEP" 7.953 KB 15 rows
. . exported "INFODBA"."PS4_FEPREVISION" 6.281 KB 15 rows
. . exported "INFODBA"."PS4_GASKETSFOAMSEALSLH" 6.421 KB 19 rows
. . exported "INFODBA"."PS4_GASKETSFOAMSEALSRH" 6.421 KB 19 rows
. . exported "INFODBA"."PS4_GLASSPRODUCTSLH" 5.992 KB 2 rows
. . exported "INFODBA"."PS4_GLASSPRODUCTSRH" 6.039 KB 4 rows
. . exported "INFODBA"."PS4_HOMLOGTIONCHNGFRMSTORAGE" 11.71 KB 51 rows
. . exported "INFODBA"."PS4_INDUSENGGCOSTFORMSTORAGE" 13.05 KB 49 rows
. . exported "INFODBA"."PS4_ISSUEREPORTREVISION" 10.39 KB 6 rows
. . exported "INFODBA"."PS4_LAUNCHMNGRCOSTFRMSTORAGE" 8.601 KB 49 rows
. . exported "INFODBA"."PS4_LHNUMBER" 6.312 KB 15 rows
. . exported "INFODBA"."PS4_MATERIALCOSTFORMSTORAGE" 31.80 KB 51 rows
. . exported "INFODBA"."PS4_METALCOMPONENTSLH" 6.437 KB 20 rows
. . exported "INFODBA"."PS4_METALCOMPONENTSRH" 6.390 KB 18 rows
. . exported "INFODBA"."PS4_MFGENGGCOSTFORMSTORAGE" 15.70 KB 49 rows
. . exported "INFODBA"."PS4_MOTORMECHANISAMLH" 0 KB 0 rows
. . exported "INFODBA"."PS4_OPENLH" 6.914 KB 39 rows
. . exported "INFODBA"."PS4_OPENRH" 6.789 KB 34 rows
. . exported "INFODBA"."PS4_PAINTCOSTFORMSTORAGE" 18.20 KB 52 rows
. . exported "INFODBA"."PS4_PLASTICCOMPONENTSLH" 7.117 KB 47 rows
. . exported "INFODBA"."PS4_PLASTICCOMPONENTSRH" 6.593 KB 26 rows
. . exported "INFODBA"."PS4_PRJMNGRESTMCSTFRMSTORAGE" 19.07 KB 146 rows
. . exported "INFODBA"."PS4_PROJMNGRCOSTFORMSTORAGE" 35.47 KB 92 rows
. . exported "INFODBA"."PS4_PURCHASINGCOSTFRMSTORAGE" 14.89 KB 49 rows
. . exported "INFODBA"."PS4_QUALITYCOSTFORMSTORAGE" 31.82 KB 52 rows
. . exported "INFODBA"."PS4_RFQ" 12.42 KB 37 rows
. . exported "INFODBA"."PS4_RFQREVISION" 7.945 KB 47 rows
. . exported "INFODBA"."PS4_RFQREVMASTERS" 6.765 KB 13 rows
. . exported "INFODBA"."PS4_RHNUMBER" 6.601 KB 27 rows
. . exported "INFODBA"."PS4_SAFETYCOSTFORMSTORAGE" 8.656 KB 49 rows
. . exported "INFODBA"."PS4_SALESCOSTFORMSTORAGE" 18.62 KB 50 rows
. . exported "INFODBA"."PS4_SMRBIDDOCREVISION" 6.75 KB 23 rows
. . exported "INFODBA"."PS4_SMRDESIGN" 28.78 KB 587 rows
. . exported "INFODBA"."PS4_SMRDESIGNREVISION" 21.03 KB 594 rows
. . exported "INFODBA"."PS4_SMRDOCUMENT" 9.437 KB 10 rows
. . exported "INFODBA"."PS4_SMRDOCUMENTREVISION" 5.734 KB 12 rows
. . exported "INFODBA"."PS4_SMRDRAWING" 8.757 KB 20 rows
. . exported "INFODBA"."PS4_SMRDRAWINGREVISION" 6.804 KB 22 rows
. . exported "INFODBA"."PS4_SMRLIBDOC" 6.875 KB 2 rows
. . exported "INFODBA"."PS4_SMRLIBDOCREVISION" 5.546 KB 2 rows
. . exported "INFODBA"."PS4_SMRPARTREVISION" 32.14 KB 524 rows
. . exported "INFODBA"."PS4_SMRRFQDOC" 7.367 KB 53 rows
. . exported "INFODBA"."PS4_SMRRFQDOCREVISION" 6.867 KB 73 rows
. . exported "INFODBA"."PS4_SMRTOOLDESIGN" 9.882 KB 1 rows
. . exported "INFODBA"."PS4_TOOLINGCOSTFORMSTORAGE" 11.33 KB 50 rows
. . exported "INFODBA"."PSAT_RANGES" 6.632 KB 7 rows
. . exported "INFODBA"."PSCHEDULE" 11.86 KB 3 rows
. . exported "INFODBA"."PSCHEDULEMEMBER" 8.382 KB 3 rows
. . exported "INFODBA"."PSCHEDULEMEMBER_TAGLIST_0" 6.484 KB 3 rows
. . exported "INFODBA"."PSCHEDULEREVISION" 19.65 KB 3 rows
. . exported "INFODBA"."PSCHEDULETASK" 9.031 KB 7 rows
. . exported "INFODBA"."PSCHEDULETASKREVISION" 9.976 KB 7 rows
. . exported "INFODBA"."PSCHMGTCOSTFORMSTORAGE" 7.828 KB 7 rows
. . exported "INFODBA"."PSCOPED_PROPERTY_NAME" 6.546 KB 25 rows
. . exported "INFODBA"."PSCOPED_TYPE_NAME" 6.648 KB 25 rows
. . exported "INFODBA"."PSCOPED_TYPE_NAME_0" 9.656 KB 110 rows
. . exported "INFODBA"."PSCTYPEDATA" 6.828 KB 11 rows
. . exported "INFODBA"."PSECONDARYOBJECTS" 6.398 KB 1 rows
. . exported "INFODBA"."PSEQUENCE" 6.132 KB 9 rows
. . exported "INFODBA"."PSIGNOFF" 45.77 KB 280 rows
. . exported "INFODBA"."PSMLB0" 16.88 KB 4 rows
. . exported "INFODBA"."PSMLB1" 17.88 KB 15 rows
. . exported "INFODBA"."PSOURCEOBJ" 10.51 KB 41 rows
. . exported "INFODBA"."PSPECTEMPLATE" 5.546 KB 2 rows
. . exported "INFODBA"."PSRC_DATASET_TYPE_NAMES" 7.976 KB 41 rows
. . exported "INFODBA"."PSTART_VALUE" 6.132 KB 9 rows
. . exported "INFODBA"."PSTRUCTURE_REVISIONS" 7.023 KB 17 rows
. . exported "INFODBA"."PSTXT" 12.50 KB 5 rows
. . exported "INFODBA"."PSUN_RANGES" 6.585 KB 6 rows
. . exported "INFODBA"."PSYSTEM_DATA_STRINGS" 6.148 KB 6 rows
. . exported "INFODBA"."PTASKDEPENDENCY" 5.968 KB 1 rows
. . exported "INFODBA"."PTASKEXECUTIONFORMINFO" 10.39 KB 7 rows
. . exported "INFODBA"."PTASKINBOX" 14.75 KB 219 rows
. . exported "INFODBA"."PTASKSCHEDULINGFORMINFO" 9.914 KB 7 rows
. . exported "INFODBA"."PTASKTYPE" 9.257 KB 26 rows
. . exported "INFODBA"."PTCCALENDAR" 11.85 KB 6 rows
. . exported "INFODBA"."PTC_PREFERENCES" 8.671 KB 56 rows
. . exported "INFODBA"."PTC_PROJECT" 21.78 KB 52 rows
. . exported "INFODBA"."PTC_USERCONTEXT" 8.484 KB 6 rows
. . exported "INFODBA"."PTEMPLATEDATATYPE" 5.578 KB 3 rows
. . exported "INFODBA"."PTHU_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PTOOL" 20.47 KB 63 rows
. . exported "INFODBA"."PTRANSFERMODE" 20.54 KB 85 rows
. . exported "INFODBA"."PTRANSFEROPTIONSET" 11.36 KB 20 rows
. . exported "INFODBA"."PTUE_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PTYPEBMOPERATION" 30.95 KB 794 rows
. . exported "INFODBA"."PTYPECONSTANT" 10.38 KB 96 rows
. . exported "INFODBA"."PTYPEDEF" 20.36 KB 389 rows
. . exported "INFODBA"."PTYPE_SCOPE" 6.031 KB 3 rows
. . exported "INFODBA"."PUNCT_DICT" 21.67 KB 15 rows
. . exported "INFODBA"."PUNITOFMEASURE" 6.101 KB 7 rows
. . exported "INFODBA"."PUSER" 24.81 KB 73 rows
. . exported "INFODBA"."PUSERS_0" 7.070 KB 18 rows
. . exported "INFODBA"."PUSER_INBOX" 10.32 KB 73 rows
. . exported "INFODBA"."PUSER_PATHS" 6.601 KB 18 rows
. . exported "INFODBA"."PVALIDATIONAGENTREVISION" 6.023 KB 2 rows
. . exported "INFODBA"."PVALIDATIONDATA" 13.42 KB 2 rows
ORA-31693: Table data object "INFODBA"."PVALIDATION_ARGUMENTS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALIDATION_ARGUMENTS_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALTOOLAGENT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALTOOLAGENTREVISION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUES_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUE_FILTERS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUE_FILTERS_INDEXES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUE_FILTER_CONDITIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVALUE_TYPE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PVIEWED_BY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PWED_RANGES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."PWELDPOINTREVISIONMASTER" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."SCRATCH_TABLE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "INFODBA"."VARIANT_KEY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "SCOTT"."DEPT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "SCOTT"."SALGRADE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."ACCT_TABLE" 0 KB 0 rows
. . exported "INFODBA"."AUDITLOG" 0 KB 0 rows
. . exported "INFODBA"."BOM_ACCT_TABLE" 0 KB 0 rows
. . exported "INFODBA"."BOM_RECIPE_TABLE" 0 KB 0 rows
. . exported "INFODBA"."EXPORT_TO_SITE_TABLE" 0 KB 0 rows
. . exported "INFODBA"."EXP_OBJ_TABLE" 0 KB 0 rows
. . exported "INFODBA"."IMAN_CURVEDATA" 0 KB 0 rows
. . exported "INFODBA"."IMAN_MVLBLOB" 0 KB 0 rows
. . exported "INFODBA"."IMAN_PROXYTEXT" 0 KB 0 rows
. . exported "INFODBA"."MFK_WORK_OBJPIDS" 0 KB 0 rows
. . exported "INFODBA"."MMV_EQUIVALENT_THREADS" 0 KB 0 rows
. . exported "INFODBA"."MMV_SPATIAL_CELL_INDEX" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCARCHREF" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCCHILDITEM" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCDATA" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCDATAQUALIFIER" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCFLAGS" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCGDEOBJECT" 0 KB 0 rows

HOME

Monday 7 February 2022

Impdp Example using remap_schema and remap_tablespace parameter

Thursday 10 December 2020

IMPDP Error : RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037

Monday 5 October 2020

EXPDP - Example and Commands

Monday 23 March 2020

expdp Master Table error ORA-31633:

Monday 11 November 2019

EXPDP -Error - ORA-31626,ORA-31633,ORA-06512, ORA-06512,ORA-00955

Wednesday 23 October 2019

expdp - permission error ORA-31693, ORA-31617