Link to home
Start Free TrialLog in
Avatar of gotetioracle
gotetioracle

asked on

some tables missing while i am exporting schema using EXP command

hi,

Can somebody guide me .
some tables missing while i am exporting schema using EXP command.

My database version is oracle 11g r2 enterprise edition on windows 2008 R2 64 bit

Regards,
GSK
Avatar of Sean Stuber
Sean Stuber

what is the command line you are using?

what tables are missing?
Can you show us the errors you get in your export logfile?
are you exporting full database or just a schema? If a particular schema, it might mean that the tables that are missing are not part of that schema
Avatar of gotetioracle

ASKER

hi gerwinjansen/YZlat/ sdstuber

I am using exp command.I am not getting errors while exporting it is successfully exporting.

Regards,
GSK
what is the command you are issuing - all of it, all options, if you have a parameter file, what's in it?

what tables are missing?  how do you know they are missing?
hi sdstuber,

I am exporting it from one db schema to other db schema using exp command.when i comparing both the schemas after importing i am able to see some tables missing
@gotetioracle - can you post the commands you are using for both export and import?
Have a look in you import logfile, any errors there? Please provide the experts with the information requested, otherwise it'll be difficult to help you out...
please provide the "real" details.
Hi,

I have a db which is enterprise edition i am using EXPDP method for taking dmp and in log generated i am able to see all tables .But when iam Doing IMPDP into a DB which is in standard edition some tables are missing .For your reference i am attaching scripts I am using it

Regards,
GSK
IMPDPETRANS.sh
EXPDPETRANS.sh
Hi sdstuber,

I have a db which is enterprise edition i am using EXPDP method for taking dmp and in log generated i am able to see all tables .But when iam Doing IMPDP into a DB which is in standard edition some tables are missing .For your reference i am attaching scripts I am using it

Regards,
GSK
EXPDPETRANS.sh
IMPDPETRANS.sh
Can you post an import- and export logfile as well?
Btw: next time, it would be better to remove usernames/passwords from scripts. I'll ask a moderator to remove them.
gerwinjansen,


Script contains dummy user name and password
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial