| exports [message #53896] |
Wed, 16 October 2002 10:17  |
sai
Messages: 27
Registered: October 2001
|
Junior Member |
|
|
I have applications having their respective tablespaces
in an instance.when I do an export the export captures
both the tablespaces?
How can I export them separately?Does anyone have any scripts?It would be of immense help
Thanks
Sai
|
|
|
|
| Re: exports [message #53897 is a reply to message #53896] |
Wed, 16 October 2002 10:35  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
No db version - hard to give exact solution. Assuming the latest 9i release:
Include in your export parameter file TABLESPACE= and you will get all objects in this tablespace.
The TABLESPACES parameter specifies that all tables in the tablespace be exported to the Export dump file. This includes all tables contained in the list of tablespaces and all tables that have a partition located in the list of tablespaces. Indexes are exported with their tables, regardless of where the index is stored.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
