Is it possible to transport procedures during tablepspace transport..?

[skdas]

Hi,

During transport tablespace, it transports tables, indexes constraints etc.


But it does not transport the procedures. Any way out for this..?

SK

[pando]

no, source are stored in tablespace system (data dictionary)

[svk]

But moving packages and procedures is always easy because you always have access to the code.

[skdas]

Actually the Database from where I want to move to other Database through tablespace transportation, I donot have the exact version of the Stored Procedures and Package.

In the present scenario I see in the TOAD software (From QUEST). It allows me to generate the scripts for the stored procedures and Packages. After I generate the scripts, I can compile the scripts at the destination Database, after the tablespace transportaion.

Is there any better way than this...? Please let me know.

Thanks..

SKD

[svk]

Look at DBA_SOURCE view and you will not need TOAD to do this.