Pages

▼
Showing posts with label Data Pump. Show all posts
Showing posts with label Data Pump. Show all posts
Sunday, 25 November 2018

ORA-31693 ORA-02354: error in exporting/importing data ORA-01555: snapshot too old

›
Error: ORA-31693: Table data object "MIS"."MASTER_MISDB" failed to load/unload and is being skipped due to error: O...
Thursday, 16 March 2017

Export/Import in Datapump using query parameter

›
Purpose Enables  you to filter the data that is exported by specifying a clause for a SELECT  statement, which is applied to all/multip...
1 comment:
Thursday, 12 May 2016

Export Backup exclude table in Data Pump Error: ORA-39071

›
Error : ORA-39001: invalid argument value ORA-39071: Value for EXCLUDE is badly formed. ORA-00911: invalid character Solution: [ora...
1 comment:
Thursday, 24 March 2016

ORA-31634 job already exists ORA-31664 unable to construct unique job name when defaulted

›
Error : With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-31634: job already exists ORA-31664: unable ...
1 comment:
Wednesday, 12 November 2014

How to Prevent ORA-39000 ORA-31640 ORA-27037 Errors When Performing DataPump Export/Import

›
APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 and later Information in this document applies to any platform. GOA...
1 comment:

DataPump Import (IMPDP) Fails With Errors ORA-39001 ORA-39000 ORA-31640 ORA-27037

›
APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2] Information in this document appl...
1 comment:
Sunday, 7 September 2014

Export/Import specific tablespace using Data Pump in Oracle 10g Database

›
1.   Tablespace Export expdp system/ TABLESPACES=USERS,UNDOTBS1 directory=DATA_PUMP_DIR dumpfile=test.dmp LOGFILE=exp.log    parallel=2...
1 comment:
Tuesday, 24 June 2014

ORA-39068 ORA-01950: no privileges on tablespace ORA-39097: Data Pump job encountered unexpected error -1950

›
Error: ORA-39006: internal error ORA-39068: invalid master table data in row with PROCESS_ORDER=-3 ORA-01950: no privileges on tablespa...
1 comment:
Thursday, 3 October 2013

EXP-00026: conflicting modes specified

›
Problem: exp scott/tiger@orcl owner=hr FULL=Y ROWS=N file=D:\as_03102013.dmp log=D:\as_03102013.log statistics=none buffer=10000 Desc...
1 comment:

Copying Database Structure Without Data Using exp/imp

›
This is a very good way to get the DDL of your database objects so that you can re-create a view or stored procedure without having to perf...
Wednesday, 18 September 2013

Oracle Data Pump (expdp and impdp) in Oracle Database 10g

›
Oracle Data Pump (expdp and impdp) in Oracle Database 10g For the examples to work we must first unlock the SCOTT account and...

Oracle Data Pump using Database link in Oracle Database 10g

›
Oracle Data Pump using Database link in Oracle Database 10g Posted on July 29, 2013 Network Exports/Imports (NETWORK_LI...
1 comment: