Re: How to use the new database?

If you do it on the server machine:
Change your ORACLE_SID, then run sqlplus as usual.

If you do it on a client PC:
Update your tnsnames.ora to create a new entry to point to the new instance. Make sure you also update the listener.ora on the server to start a listener for the new instance. Run SQL*Plus on the client PC using the new connect string.

Hope this help!

Raymond Li wrote:
>
> Hello,
> I have managed to create a new database using Instance Manager
> (well, I haven't used any create database statement, is this ok? ). Now,
> apart from the ORCL SID, another SID, PI, is running.
>
> I want to create tables on the new database. However, how can I
> connect to the new database and create object on it? Or, what should I
> do next after creating the SID?
>
> Thanks for your advices in advance!
>
> Raymond Li
 

-- 
------------------------------------------------------------
Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com
------------------------------------------------------------