backup the source database and restore it in the destination database
take backup of source database
use below parameters
full=y
file=dumpfilename
log=logfilename
consistent=y
buffer=1024000
statistics=none
compress=n
scp the dump file from source to destination server
In the destination database, you need to have space in both the filesystem and the database. In the filesystem, it is enough if you have 1/3 rd or may be 1/4 th of the total source database size as it is only the raw data that resides in the filesystem.
Note down the datafile locations for the tablespaces
remove all the non default users, roles, profiles and the non-default tablespaces including the contents and datafiles.
remove the datafiles physically.
create the tablespaces from the source database
create roles and profiles
create users
vi imp.par
-----------
file=dumpfile
full=y
buffer=1024000
log=logfile
statistics=none
ignore=y
commit=y
No comments:
Post a Comment