Solved

some tables missing while i am exporting schema using EXP command

Posted on 2013-01-09
14
496 Views
Last Modified: 2013-02-24
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
0
Comment
Question by:gotetioracle
  • 5
  • 4
  • 3
  • +1
14 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 38758986
what is the command line you are using?

what tables are missing?
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 38759311
Can you show us the errors you get in your export logfile?
0
 
LVL 35

Expert Comment

by:YZlat
ID: 38759336
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
0
 

Author Comment

by:gotetioracle
ID: 38761351
hi gerwinjansen/YZlat/ sdstuber

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

Regards,
GSK
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 38761515
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?
0
 

Author Comment

by:gotetioracle
ID: 38762227
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 38762399
@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...
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 38762618
please provide the "real" details.
0
 

Author Comment

by:gotetioracle
ID: 38773306
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
0
 

Author Comment

by:gotetioracle
ID: 38773628
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
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 38773888
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.
0
 

Author Comment

by:gotetioracle
ID: 38793950
gerwinjansen,


Script contains dummy user name and password
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen earned 500 total points
ID: 38798517
Thx, how about posting (sanitized) exp and imp logfiles?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now