Re: Can I add an existing tablespace to an new database?

no for Oracle 8.0.x and downward.
yes for Oracle 8i: use transportable tablespace option in export and import to another database as another tablespace.

HTH John Chiu

Troy Tinnes <q10641_at_cig.nml.mot.com> wrote in message news:3868405C.9A4B8617_at_cig.nml.mot.com...
> Nope. What you need to do is create the tablespace on the new database,
export
> all the tables belonging to the target tablespace from the old database
and
> import into the new. - an excellent opportunity for extent compression and
> general cleanup!
>
> - Troy
>
> Appie at InfoPAct wrote:
>
> > Dear All,
> >
> > While migrating an Oracle Database from one NT server to an other NT
said
> > pute and got all blue.
> > Since then when I want to open the database, I got a message ORA-01159
and
> > sometimes ORA-01206,
> > meaning that the tablespace I want to add to the new database has A
WRONG
> > DATABASE ID.
> >
> > Is there a way to add an existing tablespace to an new Instance whithout
> > losing the data in it??????
> >
> > Thanks a lot
> >
> > Ab.
>
Received on Tue Dec 28 1999 - 06:24:58 CST