Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp (Transportable Tablespace)

Re: exp/imp (Transportable Tablespace)

From: bdbafh <bdbafh_at_gmail.com>
Date: Mon, 12 Nov 2007 22:05:38 -0000
Message-ID: <1194905138.917196.231400@v65g2000hsc.googlegroups.com>


On Nov 12, 5:03 pm, Tom76 <br..._at_hotmail.com> wrote:
> 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.

Start from scratch with the concepts manual.

-bdbafh Received on Mon Nov 12 2007 - 16:05:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US