| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I add an existing tablespace to an new database?
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!
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 Mon Dec 27 1999 - 22:45:16 CST
 |
 |