RE: Build an exact copy of a database using export / import

Well, depending on the size of the db and some other network stuff, I do the following. I shut down the real db, copy all of the data files, controlfiles and init file to a machine with Oracle on it. Then you can create the service (NT), alter any of the datafiles if necessary (on different logical drive) then you can just bring that bad boy up. Then I just give it a different alias, works for me.

        However, what do you mean it creates new tablespaces, I have never seen that happen, it just fails miserably for me if the tablespaces don't exist. You could do the full export, create a new user on the new machine and grant "become any user" to the new user. I believe that then the import would work, I've done it before. Sorry I don't have more, brain is still a littel soft from the weekend.
Kev

-----Original Message-----
L.
Sent: Wednesday, May 30, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L

When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import?

Thanks!
Ron Smith
Database Administration
rlsmith_at_kmg.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).