Re: system tables in user table space

A copy of this was sent to Anurag <anurag_at_synergy-infotech.com> (if that email address didn't require changing) On Sat, 04 Dec 1999 04:10:29 -0800, you wrote:

>Hi,
>Recently I have noticed that some of the system tables are present in
>the user tablespace on my clients database.
>Following is the procedure I am planning to use to fix it. Please
>confirm whether this is the correct way or there is some better way to
>tackle this problem
>

stop: don't do anything.

what system tables?

>step1
>-----
>export the user schema
>
>step2
>-----
>drop the database and recreate it.(I have the initial script)
>
>step3
>-----
>Import the user schema with all the objects
>
>step4
>-----
>drop the redundant system tables (They are already created now in the
>system table space)
>
>Also please let me know how do I drop the database.
>
>Any help will be appreciated.
>
>Thanks
>Anurag
>
>also reply at
>anurag_at_synergy-infotech.com
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 08:14:39 CST