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

Making something "dirt" you can save the datafile (all, control and logs included) of your old instance, create another on the other machine with the SAME sid, path, and all of the old... then after the creation overwrite the dbfiles with your olds.
Maybe it can help (I swear that it goes ..) ....

Or you can try to add a tablespace on your new db telling him (the db) to use existing datafile (not to create one), and put your old in ...

bye

>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 - 15:27:07 CST