You Asked

Hi Tom,

It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import. We've lost impdp logs, How could we get information about the impdp command that was run and clarify the issue?

Thanks a lot
Regards!

and Connor said...

How could we get information about the impdp command that was run and clarify the issue?

Well...that is what the logs are for.

It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import

I'm not entirely sure what you mean by this?

Rating

(1 rating)

Comments

A reader, March 25, 2025 - 7:28 am UTC

Good Morning

I run a impdp command with remap_table option but at the same hour somebody or something run a full import.

Is there a way to execute a full import without explicitly specifying it in the impdp command options with full=yes? For instance, by entering wrong options in the par file.

How or where can I see any trace of what could have happened?

Thanks in advances
Regards!

April 04, 2025 - 2:18 am UTC

If someone has done "expdp full=y dumpfile=myfull.dmp...."

then if they run an impdp on that file, we will automatically know its a full export and act accordingly.

eg

C:\>expdp system/admin dumpfile=full19s.dmp directory=temp full=y

Export: Release 19.0.0.0.0 - Production on Fri Apr 4 10:11:53 2025
Version 19.26.0.0.0

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

UDE-28002: operation generated ORACLE error 28002
ORA-28002: the password will expire within 7 days

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** dumpfile=full19s.dmp directory=temp full=y
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
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
...
...
...
. . exported "ORDS_METADATA"."SEC_SESSIONS"                  0 KB       0 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  C:\TMP\FULL19S.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Fri Apr 4 10:14:04 2025 elapsed 0 00:02:09


C:\>impdp system/admin dumpfile=full19s.dmp directory=temp 

Import: Release 19.0.0.0.0 - Production on Fri Apr 4 10:14:25 2025
Version 19.26.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "SYSTEM"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_SQL_FILE_FULL_01":  system/******** dumpfile=full19s.dmp directory=temp sqlfile=full19s.sql
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
...
...

Besides the logs, there really isn't a record of it in the database (once the task has completed)

Perhaps check your audit logs in the database (depending on what audit options you have enabled)

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.

Breadcrumb

Question and Answer

You Asked

and Connor said...

Rating

Comments

More to Explore

Data Pump

Importdp with remap_table has run a full import

Breadcrumb

Question and Answer

You Asked

and Connor said...

Rating

Comments

More to Explore

Data Pump