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
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
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
ASKER
hi gerwinjansen/YZlat/ sdstuber
I am using exp command.I am not getting errors while exporting it is successfully exporting.
Regards,
GSK
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?
what tables are missing? how do you know they are missing?
ASKER
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
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...
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.
ASKER
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
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
ASKER
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
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.
Btw: next time, it would be better to remove usernames/passwords from scripts. I'll ask a moderator to remove them.
ASKER
gerwinjansen,
Script contains dummy user name and password
Script contains dummy user name and password
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what tables are missing?