Re: Created a tablespace in another database file

Bret,

Can you be more specific on the problem. Do you mean they share the same datafile (not tablespace)?

Without knowing the specifics (including going back over the alert logs for both databases, which will give many of the steps leading to your situation), my gut says:

1. Use the drop command to drop the tablespaces using the datafile in both databases.
2. use the drop command to drop the datafile in both database.

Again without knowing the specifics, I can say this will work.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"Bretg" <bretg80_at_yahoo.com> wrote in message 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:57:28 CST