Home > IT Answers > Oracle > Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i
Vini Chandamama
100 pts.
 Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i
Oracle 9i, Oracle 9i export parameters, Oracle import/export, TABLESPACES, TRANSPORT_TABLESPACE
Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

Software/Hardware used:
ASKED: June 24, 2008  5:53 AM
UPDATED: August 23, 2008  3:46 AM
RELATED QUESTIONS
Answer Wiki:
Hi Vini, could you explain what do you need? You cannot use the option (tablespaces , transport_tablespace) and full in the same export command line, they are not compatible. bye Marco hi, No need to include tablespaces, transport_tablespaces in the exp command while using full=y. When we need to export data for certain tablespace then we we use export in tablespace mode and transport tablespace is used where we move tablespaces from one database to another which are of different blocksizes. Hope this helps. regards http://www.oracledbarea.blogspot.com
Last Wiki Answer Submitted:  August 23, 2008  3:46 am  by  FreCho   80 pts.
All Answer Wiki Contributors:  FreCho   80 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If you’re interested in Oracle export options, you may also be interested in this compliation of questions and answers from SearchDatabase.com’s resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland. They provide explanations, step-by-step instructions and example scripts, and talk about what can and cannot be exported.

BrentSheets
 6,580 pts.
 

Hi BrentSheets ,

I have finished my job of export.
Thanks for the information.

Vini Chandamama
 100 pts.