| Oracle database copy [message #55937] |
Tue, 25 February 2003 14:59  |
master_muddle
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Unfortuantely being only Ingres trained, and reletavely new to the Oracle/Unix environment with an employer who strongly beleives in on-the job training - I need some advice on the easiest way of copying a live database completely over an existing training database on Oracle 8.1 running on Unix.
This used to be a simple file copy in Ingres, but I'm not sure of best approach for Oracle.
Thanking you in anticipation
mm
|
|
|
|
| Re: Oracle database copy [message #55958 is a reply to message #55937] |
Wed, 26 February 2003 15:18  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
If you mean single time taking image of the production db - then full consistent db export and then import will do the job.
If you however have to resync this image over the time - then Replication is your other choice.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
