expdp – oracle database admin diary

How to Exclude Data for Specific Tables in Datapump Import (IMPDP)

Sometimes it is necessary to exclude data for some tables in a datapump import. In this post we will look at how to do that. SOLUTION We will do this…

Comments Off

October 19, 2024

Data Pump (Import/Export)

Stop A Running Datapump (expdp/impdp) Job Started In the Background

This article demonstrates how to stop a running datapump (expdp/impdp) job started in the background. Assuming a job was started in the background on Linux this way: $ nohup ./imp_SCHEMAS_script.sh…

Comments Off

September 10, 2024

Data Pump (Import/Export)

PLS-00201: identifier ‘SYS.DBMS_CUBE_EXP’ must be declared

While performing Data pump export (expdp) the following errors were seen in the log file. The Oracle RDBMS version was 19.3.0.0.0 BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'19.00.00.00.00'); END; ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06550:…

Comments Off

September 10, 2024

M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31