Re: exp/imp (Transportable Tablespace)

"Tom76" <brk15_at_hotmail.com> schreef in bericht news:1194904986.206183.41700_at_o38g2000hse.googlegroups.com...
> 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.
>

Hopefully it helps YOU! It just says what the others already told you!

Shakespeare Received on Tue Nov 13 2007 - 12:50:55 CST