Hi, 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
+1
A:
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.
MJB
2010-04-01 12:32:22
and how do I export tables by a specific user?
Adomas
2010-04-01 12:34:27
It has been a little while, so I am not 100% certain of syntax, but it is something like:exp user/pass file=xxx.dmp user=(username1, username2)
MJB
2010-04-01 12:42:42
thanks very much :) if this will not work, I've thought of another way which seems to work in small databases..
Adomas
2010-04-01 12:45:22
I forgot that you can also do exp ... tables=(table1, table2) and fromuser and touser stuff. Exp has a lot of options -- two columns of them I believe -- so I would bet that it will do what you want.
MJB
2010-04-01 12:48:59
A:
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
Oliver Michels
2010-04-01 13:03:19