| export with wildcard characters and dependant objects [message #211251] |
Wed, 27 December 2006 10:41  |
jaydba
Messages: 86
Registered: September 2006
Location: UK
|
Member |
|
|
I need to take export backup for transaction tables starts with 'T%' associated with one of the tablespace test. There are other tables like start with 'H%' associated for the same tablespaces.
exp jtest/jtest file='/u01/app/oracle/oradata/test.dmp' log='/u01/app/oracle/oradata/test.log' consistent=y tables=t%
I can take simply export backup using 'T%' but I wanted to take export backup for all other assocated objects like index,view,triggers,functions etc. at the same time.
I can go for user-wise export but I wanted to take backup for 'T%' tables and other objects as mentioned in the dump file.
Can you suggest me the best way to perform this job?
|
|
|
|
|
|
|
|
| Re: export with wildcard characters and dependant objects [message #211260 is a reply to message #211259] |
Wed, 27 December 2006 11:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
dbms_metadata works only after 9i.
>>You can extract it from the dumpfile itself
just use show=y during the import.
Something like this
imp user/pass file=mydump.dmp log=somefile.sql show=y
Using show=y will not actually do any import.
Instead the text ddl will dumped into somefile.sql
It is not pretty. But you get the ddl.
Much simple option is to use GUI tools.
>>Can you please send me the procedure for above mentioned thing how to perform technically?
Please search the forum. We have answered it a zillion times before
[Updated on: Wed, 27 December 2006 12:07] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
