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

Ron,

You can export them, and then import into the new acct using the FROMUSER/TOUSER params.

If you do the export as SYSTEM, then the user acct(s) will have to have DBA to do the import (only DBAs can import stuff exported by DBAs)

Regards,
Charles_Dye_at_corp.dialog.com

In article <49enai$cav_at_mrnews.mro.dec.com>, ronald_at_mix004.nwg.dec.com (Ronald van der Burg) writes:
> 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?
>
> Thanks in advance!
>
> Ronald van der Burg
>
Received on Tue Nov 28 1995 - 00:00:00 CET