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

From: Jim Gregory <jim.gregory_at_DaytonOH.attgis.com>
Date: 1995/11/28
Message-ID: <DIrMDu.54M_at_intruder.daytonoh.attgis.com>#1/1

>>==========Ronald van der Burg, 11/28/95==========
>>
>>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
>>
>>
If I understand your problem, you've created the tables while logged into ORACLE as the system schema or user. If the tables are not populated, just drop them, log into the desired schema, and re-create the tables. If the tables are populated you can log into the desired schema and use:

	create table <tabname> as 
		select * from system.<tabname>

HTH
Jim Gregory

Views and opinions expressed are mine and do not reflect my empoyer's or client's. Received on Tue Nov 28 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Ronald van der Burg: "How can users be arranged into a group?"
Previous message: Charles Dye: "Re: How can system tables be converted to user tables?"
In reply to Ronald van der Burg: "How can system tables be converted to user tables?"
Next in thread: Chuck Hamilton: "Re: How can system tables be converted to user tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message