Re: exp/imp (Transportable Tablespace)

On Nov 12, 1:09 pm, Tom76 <br..._at_hotmail.com> wrote:
> Transportable Tablespace feature
>
> source db: 9i
> target db: 10g
> OS: source and target is Linux.
> Tested a migration of few application tablespaces using Transportable
> Tablespace feature. Packages, procedures did not get migrated.
> There is no option to specify paackages or procedures to be
> exported(exp or imp). So I guess they get exported/imported
> automatically.
> No errors during the transportable tablespace procedure. Any idea why
> the packages and procedures did not get migrated.

Since none knew(specially from the above replies and were very confused).....I found this....

"User-defined function, user-defined operator, etc. Oracle allows these definitions to appear in the following forms: SQL, PL/SQL, packages, C callouts. Defining in SQL is always transportable. PL/ SQL, packages and C callouts are external to tablespaces. They need to be migrated or ported, in case of C callouts, in addition to the tablespace transport. "

Hopefully it helps others. Received on Mon Nov 12 2007 - 16:03:06 CST