Export and import question.# Database - 数据库
s*m
1 楼
Hi,
I am trying to create a test oracle database from a life oracle database.
Both databases have exact same schemas and are on two machines running Linux.
Now i already have everything in the test database except the table data. I
need to import the data from the life database. I have tried the following to
export data from life database. This is my parfile.
##############expfile.par########################
userid=user/[email protected]
file=expdat1.dmp
log=exp.log
tables=table1,table2,....
#######
I am trying to create a test oracle database from a life oracle database.
Both databases have exact same schemas and are on two machines running Linux.
Now i already have everything in the test database except the table data. I
need to import the data from the life database. I have tried the following to
export data from life database. This is my parfile.
##############expfile.par########################
userid=user/[email protected]
file=expdat1.dmp
log=exp.log
tables=table1,table2,....
#######