Re: Created a tablespace in another database file

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Tue, 10 Dec 2002 08:21:27 +0100
Message-ID: <uvb5nilmcgpbea@corp.supernews.com>

You can only create tablespaces in a database while being connected to it as a user with the appropriate privileges.
Two databases can *never* share a tablespace. If one of your databases has an unwanted tablespace you just have to drop it and recreate it in the other.

regards,
Peter

"Bretg" <bretg80_at_yahoo.com> schreef in bericht news:74acbad3.0212092248.64af4efd_at_posting.google.com...
> Somehow Oracle 8.1.7 on linux allowed me to create a tablespace in
> another database. These two databases use the same index tablespace
> and I have no idea how I got Oracle to do this, but now that it is
> done, I can't get figure out how to fix it. I have tried to edit the
> control files using the alter database backup controlfile to trace
> command. However, when I remove the entry that points to the other
> database, then I get the infamous ORA-0600 error.
>
> I imagine I'm going to have to restore from tape unless anyone has any
> suggestions.
>
> Bret
Received on Tue Dec 10 2002 - 01:21:27 CST