Importing into a new database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Importing into a new database

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    When importing data into a new database, should the database be mounted and open, or should I only have the instance running???
    roukie-dba

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The database has to be open. I like to open the database, but stop the listener. This way, I know that no users are using the database, but the database is still operating "normal".
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    OPEN. How would you be able to create objects and/or insert data into the database if it is not open?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Marist and Juric, thanks a lot. Especially, thanks to both of you - Marist for the listener shutdown tip, and Juric for pointing out the fact that objects are being created in the new DB which automatically means it has to be open. Big thanks!!!
    roukie-dba

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