?
Solved

some tables missing while i am exporting schema using EXP command

Posted on 2013-01-09
14
Medium Priority
?
564 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 3
  • +1
14 Comments
 
LVL 74

Expert Comment

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

what tables are missing?
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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 74

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
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
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 74

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 38

Expert Comment

by:Gerwin Jansen, EE MVE
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 38

Accepted Solution

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

762 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