OraFAQ Forum: Server Utilities » Running exp and imp command on 11.2.0.1.0 Production version

Home » RDBMS Server » Server Utilities » Running exp and imp command on 11.2.0.1.0 Production version (Oracle: Release 11.2.0.1.0 Production; Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running exp and imp command on 11.2.0.1.0 Production version [message #561786]

Wed, 25 July 2012 05:36

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Hello Team,

I ran "exp" command to take a back of Oracle Db based on user and later imported(using "imp" command) the dump into another db.

Its seen that some the tables are not exported during exp command run. Can I use exp command on Oracle 11.2 version?

or should I always be using expdp command?

Thanks
Sunil Kumar

Report message to a moderator

Re: Running exp and imp command on 11.2.0.1.0 Production version [message #561787 is a reply to message #561786]

Wed, 25 July 2012 05:42

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

EXP and IMP (see Part IV) are still available in 11g, but you should not use them (see the note at the beginning of Original Export chapter). Therefore, switch to Data Pump.

Report message to a moderator

Re: Running exp and imp command on 11.2.0.1.0 Production version [message #561862 is a reply to message #561787]

Wed, 25 July 2012 18:27

alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California

Senior Member

With 11g imports from prior Oracle Versions I have had some corruption issues so I have had to
truncate or drop partially imported tables and import the tables one at a time after doing individual
table exports.

SCOTT > @cr8_exports_by_TABLE_NAME_on_Unix.sql

exp userid=myschema_login/myschema_password file=DEPT.dmp tables=\(DEPT\) log=DEPT.log
exp userid=myschema_login/myschema_password file=EMP.dmp tables=\(EMP\) log=EMP.log
exp userid=myschema_login/myschema_password file=BONUS.dmp tables=\(BONUS\) log=BONUS.log
exp userid=myschema_login/myschema_password file=SALGRADE.dmp tables=\(SALGRADE\) log=SALGRADE.log

SCOTT > list
  1  select 'exp userid=myschema_login/myschema_password file='||table_name||
  2* '.dmp tables=\('||table_name||'\) log='||table_name||'.log' from user_tables

SCOTT > @cr8_exports_by_TABLE_NAME_on_Windows.sql

exp userid=myschema_login/myschema_password file=DEPT.dmp tables=(DEPT) log=DEPT.log
exp userid=myschema_login/myschema_password file=EMP.dmp tables=(EMP) log=EMP.log
exp userid=myschema_login/myschema_password file=BONUS.dmp tables=(BONUS) log=BONUS.log
exp userid=myschema_login/myschema_password file=SALGRADE.dmp tables=(SALGRADE) log=SALGRADE.log

SCOTT > list
  1  select 'exp userid=myschema_login/myschema_password file='||table_name||
  2* '.dmp tables=('||table_name||') log='||table_name||'.log' from user_tables

Report message to a moderator

Re: Running exp and imp command on 11.2.0.1.0 Production version [message #562341 is a reply to message #561862]

Tue, 31 July 2012 08:43

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Thank you very much for clarifying. Will not be using imp/exp command to run on Oracle 11 version.

Report message to a moderator

Previous Topic:	Export/Import tables based on date condition
Next Topic:	sequence in sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 20 10:15:57 CDT 2023