clone database

ankur02018 · #1 (**permalink**) 08-17-07, 01:49

if we use

backup database livedb
and then

restore database livedb

then we can tranfer database to any machine

but if we require to transfer database with name livedbtest which
contains the same contents of live

not by export load command

guyprzytula · #2 (**permalink**) 08-17-07, 02:23

you can restore db aa into db bb (into..)
if on the same machine and specific paths are being used, then redirected restore is needed. see doc for restore and redirect

ankur02018 · #3 (**permalink**) 08-17-07, 07:17

Quote:

Originally Posted by guyprzytula

you can restore db aa into db bb (into..)
if on the same machine and specific paths are being used, then redirected restore is needed. see doc for restore and redirect

yes this is working fine If we want to change schema name for tables

then what we have to do