Check for the space in the filesystem.
Take backup of the table(s) in the source database.
vi exp.par
--------------
tables=tablename
file=dumpfilename
log=logfilename
compress=n
statistics=none
consistent=y
buffer=1024000
transfer the dumpfile from source to destination database
In the destination database,
drop the table in the destination database
check for the space in the filesystem and the destination database (tablespace).
import the table to the destination database
vi imp.par
---------------
file=dumpfile
log=logfile
fromuser=user of source database
tables=(tab1, tab2, etc.,)
rows=y
grants=y
buffer=1024000
statistics=none
No comments:
Post a Comment