Alter Database Close
Hey folks, I have a doubt could some help me in that? I am using 9i release 1 on Windows 2000 AS (Testing purpose).
Well the first one is that if we could mount the db and then open in read only mode, Can we then change the mode of the DB to read write? i.e
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN READ ONLY;
Now can i change the mode to read write????
ALTER DATABASE READ WRITE;????
That was one and the second question is I can close the Database by alter database close; but when i start the database again by alter database open or open read only i gets an error that database already opened by this instance. I just wanna be sure its a bug or something or i am doin something wrong..
Hope to see something soon from smart dudes
Stand up for your principles even if you stand alone!
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Click Here to Expand Forum to Full Width