-
Hi,
During transport tablespace, it transports tables, indexes constraints etc.
But it does not transport the procedures. Any way out for this..?
SK
-
no, source are stored in tablespace system (data dictionary)
-
But moving packages and procedures is always easy because you always have access to the code.
svk
-
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
-
Look at DBA_SOURCE view and you will not need TOAD to do this.
svk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|