Home » RDBMS Server » Server Utilities » Transportable tablespaces
Transportable tablespaces [message #378263] Mon, 29 December 2008 10:45 Go to next message
munira13
Messages: 14
Registered: March 2007
Junior Member
Hi,

I am using transportable tablespaces in order to move data. After the import however, I realized that only the table, index and trigger definitions have got imported. All the other objects like procedures, packages, functions, views etc are not present in the target instance.

Is there a way to move the above objects data using transportable tablespaces or do I need to use the regular method of export import with rows=n.
Re: Transportable tablespaces [message #378264 is a reply to message #378263] Mon, 29 December 2008 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a way to move the above objects data using transportable tablespaces

No.

Quote:
do I need to use the regular method of export import with rows=n

Or better using the scripts you should have as you have the source code of your application.
Otherwise use dbms_metadata.

Regards
Michel
Re: Transportable tablespaces [message #378269 is a reply to message #378264] Mon, 29 December 2008 11:25 Go to previous message
munira13
Messages: 14
Registered: March 2007
Junior Member
Got it!!

Thanks.
Previous Topic: sqlldr parameters to handle SQL*Loader-500: Unable to open file
Next Topic: update values in control file
Goto Forum:
  


Current Time: Sun Dec 04 18:39:00 CST 2016

Total time taken to generate the page: 0.15379 seconds