| How to create database [message #69386] |
Fri, 21 December 2001 05:51  |
Girdhari Ram Choudhary
Messages: 8
Registered: December 2001
|
Junior Member |
|
|
How to create a new database in oracle.after createting how to swtich over connection from one database to another.
----------------------------------------------------------------------
|
|
|
|
| Re: How to create database [message #69399 is a reply to message #69386] |
Sun, 23 December 2001 19:19  |
Suchi
Messages: 6
Registered: December 2001
|
Junior Member |
|
|
creating database ...
decide about controlfiles paths,log files etc.
then
1.prepare initSID.ORA.
2.Create service using ORADIM (if it is NT)
3.connect to oracle using SVRMGRL CONNECT INTERNAL/PASWORD.
4.run CRAETE DATABASE ..statements
5.run all required sql files.
go through oracle doc for more details.
MOVING BETWEEN TWO DATABASES.
on NT..
1.set oracle_sid=sid1
2.svrmgrl connect internal/password@sid1;
On Unix envoronments..
1. . oraenv
it will ask for the sid ,provide sid of the database to which you want to connect.
or
$ORACLE_SID=SID1
$EXPORT ORACLE_SID
then connect using svrmgrl or sqlplus .
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
