Re: How can system tables be converted to user tables?

Ronald van der Burg (ronald_at_mix004.nwg.dec.com) wrote:
: Hi,
 

: Thanks for reading. Currently we are trying to get an Oracle db running on a
: server. Tables have been generated, but all the tables became system tables.
: They should have been user tables. Is it possible to convert system tables to
: user tables? If so, how to do so?

What do you mean by system tables? Are the tables OWNed by system or the tables are IN SYSTEM tablespace? These are 2 different issues requiring different solutions!

By the way, make sure that the default tablespace for your users are NOT SYSTEM tablespace! It is a really, really, really bad idea to put other tables (except for "system" stuff) into the SYSTEM tablespace. Check your ORACLE documentation for more details.

Have fun.

Kim Ng Received on Wed Nov 29 1995 - 00:00:00 CET