ralph_rea
asked on
Oracle Export
Hi,
OS: Windows
DB Version: Oracle 11.2
I'm trying to export my schema TOM.
exp TOM/TOM@ORCL file=c:\exp_tom.dmp log=c:\exp.log
but I can export only tables with rows. Each table with zero rows is not exported.
Should I set some parameter to export all the tables?
Thanks in advance!
OS: Windows
DB Version: Oracle 11.2
I'm trying to export my schema TOM.
exp TOM/TOM@ORCL file=c:\exp_tom.dmp log=c:\exp.log
but I can export only tables with rows. Each table with zero rows is not exported.
Should I set some parameter to export all the tables?
Thanks in advance!
"Each table with zero rows is not exported." With 11gR2 the segments with 0 rows only get their DDL exported. Segments with 0 bytes are treated differently in 11gr2.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you post your log?
Open in new window