Re: Connection to System/Manager Question
From: robertsboyle <member21885_at_dbforums.com>
Date: Mon, 27 Jan 2003 11:17:46 +0000
Message-ID: <2441949.1043666266_at_dbforums.com>
Date: Mon, 27 Jan 2003 11:17:46 +0000
Message-ID: <2441949.1043666266_at_dbforums.com>
Rob
The schema should definitely NOT be installed in the System tablespace,
nor under the System user. You need to create a separate tablespace
(probably 2 or 3) for the schema, a separate user and move the data to
this new schema.
See http://asktom.oracle.com/pls/ask/f?p=4950:8:1961186::NO::F4950_P-
8_DISPLAYID,F4950_P8_CRITERIA:47812348053,%7Bsystem%7D%20and%20%7Btablespace
%7D
for an example of moving tables across tablespaces.
Check out tahiti.oracle.com or asktom.oracle.com for reasons why not to
use the SYSTEM tablespace and why you should have changed the password
from manager when the database was created.
hth
R.
--
Posted via http://dbforums.com
Received on Mon Jan 27 2003 - 12:17:46 CET