-
Type of Export dump
What is the best way to find out how the export was taken. I mean whether it was take in User mode Or is that a Full exp dump
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
-
Originally Posted by davey23uk
imp show=y
Say i have a exp dump which has exported tables emp,dept etc....
from the XYZ schema, which i dont know.
But when i do Show=y, it doesn't dispaly any username which would help me to specify fromuser and touser.
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
You could have a look at the export log file or even the size of the dump file should tell you if it is a full export or a partial export
thomasp
-
You could just more the dmp file.
-- This was a more from a "FULL" export, done by sys.
EXPORT:V09.02.00
DSYS
RENTIRE
---- More from a user based export ---
EXPORT:V09.02.00
DUSR1
RUSERS
8192
-- Table based export
EXPORT:V09.02.00
DSYS
RTABLES
The D Seems to be the user that was connected that performed the Export.
the R seems to be the mode (ENTIRE, USER, TABLES).
-
This is why all exports should have a logfile.
I remember when this place was cool.
-
...and a pfile.
Jeff Hunter
-
Originally Posted by marist89
...and a pfile.
HEY NOW!!
Don't make me drive up there young man!
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|