We use "Clones" of databases all the time. Its much faster than the
Export/import run. We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB name, and bring it up. Then
you have to alter the global name. Its a relatively simple process.
If there are tablespaces that were in the original one that you do not want
over then, at this point, drop any associated objects and drop the
tablespaces.
-----Original Message-----
Sent: Wednesday, May 30, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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 Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
