CODEWITHSUNDEEP
sqloracle-databasedatabase
Adomas
Adomas

Reputation: 671

Exporting many tables on Oracle

I would like to know, how to export many tables from oracle DB.

I use exp.exe, create file expdat.dmp and so on. I choose to export only tables and there I must write which ones.

Is there any chance of getting all of them?

thanks

Upvotes: 2

Views: 15609

Answers (3)

Prabhat Ganesh Yaji
Prabhat Ganesh Yaji

Reputation: 19

If tables are more, instead of mentioning them in command line, you can input them in a param file and refer it in exp command.

exp userid=scott/tiger file=dumfile.dmp log=logfile.txt PARFILE=myexp.conf

$ vi myexp.conf
tables=EMP,DEPT,SALGRADE
grants=n
triggers=n

Upvotes: 0

Oliver Michels
Oliver Michels

Reputation: 2917

You can export a specified list of tables

 exp userid=scott/tiger file=dumfile.dmp log=logfile.txt tables=EMP,DEPT,SALGRADE consistent=y buffer=1024000

Upvotes: 1

MJB
MJB

Reputation: 7686

You can export a list of tables, or you can export all tables owned by a specific user, or various other methods. The exp command, with no args, will tell you this. But it will not be all that clear -- it is usually easier to use a parm file to tell it what you want to export and how.

Upvotes: 1

Related Questions