OS: SuSE Linux Enterprise Server 8
Hello All,
I am doing exp/imp from Oracle 7.3.4 to Oracle 10.1.0.2.0.
I have done export succesfully and put dmp file on Linux server through ftp.
under /opt/oracle/documents directory.>
/opt/oracle/documents
I ran imp from command line.
imp --- as a system/password
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Production
With the Partitioning, OLAP and Data Mining options
Import
file: expdat.dmp > dn.dmp
Enter
insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V07.03.04 via
conventional path
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no >
Username: system
Enter table(T) or partition(T:P) names.
Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:
-----------------------------------------------------
---------------------------------------------
------------------------------------------
very last line as follows
: Import terminated successfully with warnings.
Note: I selected evrey thing as default on prompt after imp.
is it ok?
Prior to imp I created same tablespace name in target DB as source DB.
Do I need to create schemas in target DB as well?
Regards,
D