Home > IT Answers > Oracle > Export parameters TABLESPACES, TRANSPORT_TABL...
Help

Question

  Asked: Jun 24 2008   5:53 AM GMT
  Asked by: Vini Chandamama

Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i


Oracle 9i export parameters, Oracle import/export, Oracle 9i, TRANSPORT_TABLESPACE, TABLESPACES

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Aug 23 2008  3:46 AM GMT  by Jafar1984


Latest Contributors: FreCho


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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Database.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

BrentSheets  |   Jun 26 2008  8:19PM GMT

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.

 

Vini Chandamama  |   Jun 30 2008  5:26AM GMT

Hi BrentSheets ,

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