Oracle database export missing tables -


i've exported instance of oracle 11g database (full) without shutting down find there 400+ tables missing (were not exported). database used application , possibly had users on it.

the command used

exp system@db1 full=y file="c:\backup.dmp" grants=y rows=y log="c:\backup.log"  

would not shutting down before exporting make skip these tables?

exp not understand deferred segment creation , may not include these tables:

select owner, table_name dba_tables segment_created = 'no' order 1, 2; 

have tried expdp instead? exp deprecated in 10g, although there bugs new tool , workaround use exp. if need use exp may need run command on tables:

alter table unexported_table allocate extent; 

Comments

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -