Copy a database to same machine [message #74152] |
Mon, 20 September 2004 20:24 |
Amudan
Messages: 8 Registered: September 2004
|
Junior Member |
|
|
Hello,
Please give me the steps for copying a database in the same machine. I am using oracle 9i Database .
Thanks
Amudan.
|
|
|
Re: Copy a database to same machine [message #74154 is a reply to message #74152] |
Tue, 21 September 2004 00:46 |
rammohan
Messages: 13 Registered: March 2002
|
Junior Member |
|
|
usage: COPY FROM <db> TO <db> <opt>
{ (<cols>) } USING <sel>
<db> : database string, e.g., scott/tiger@d:chicago-mktg
<opt> : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
: name of the destination table
<cols> : a comma-separated list of destination column aliases
<sel> : any valid SQL SELECT statement
A missing FROM or TO clause uses the current SQL*Plus connection.
EXAMPLE
OPY FROM USERNAME/PASSWORD@SERVICENAME(db1) TO USERNAME/PASSWORD@SERVICENAME(DB2) APPEND man_cell USING SELECT * FROM man_cell;
|
|
|
Re: Copy a database to same machine [message #74155 is a reply to message #74154] |
Tue, 21 September 2004 01:10 |
Amudan
Messages: 8 Registered: September 2004
|
Junior Member |
|
|
Hi,
Thanks.
The issue is: Copying a entire database (using oracle9i in windows 2000) with all of its data and schema to another database in the same machine. I am in need of the procedures to execute the same in my machine.
Bye
Amudan.
|
|
|
|
Re: Copy a database to same machine [message #74160 is a reply to message #74155] |
Thu, 23 September 2004 11:28 |
croK
Messages: 170 Registered: April 2002
|
Senior Member |
|
|
if you have installed oracle database configuration assistant, you can choose to create a template based on an existing database
then, you can create new database with that template. all from DBC.
Best luck.
|
|
|