Re: Connection to System/Manager Question
Date: Mon, 27 Jan 2003 07:21:37 -0600
Message-ID: <3e3535ab$1_at_nntp01.splitrock.net>
Thanks for the timely reponse. I will forward this on to our customer.
Thanks,
Rob Panosh
"robertsboyle" <member21885_at_dbforums.com> wrote in message
news: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%7Bta-
> blespace%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 - 14:21:37 CET
