Alter Database Close
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Alter Database Close

  1. #1
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    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
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Just try it in your test environment.

    http://www.dbasupport.com/forums/sho...threadid=30890
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width