How to backup view and some tables in oracle?

Question

I have an Oracle database. On the database There are three tables (a,b,c tables) and a view (union of a and b tables).

I want to backup of a dan b tables and also the view. I used this syntax exp user/psw file=backup.dmp tables=(a,b) ,but it doesnt backup the view,only the table. How can i include the view to be backed up?

Answer 1

Use imp commnad with this parameters

imp user/pass@service file=dumpfile.dmp log=logfile.log full=y rows=n  ignore=n grants=n indexes=n

Answer 2

From Oracle 10g onward, expdp is standard export command and exp is deprecated.

expdp has include clause where in you can specify tables and views you want to export. Here is a sample command.

expdp scott/tiger@mydb schemas=MYSCHEMA
 include=TABLE:"IN ('A', 'B','C')",VIEW:"IN('my_view')"  
 directory=MY_DIR dumpfile=Exp_ABC_MyView.dmp logfile=expdpExp_ABC_MyView.log

Further you can export only object definitions or data or both as well. more examples in https://oracle-base.com/articles/10g/oracle-data-pump-10g

Answer 3

You can not include a view to be backed up while using the "exp" utility. Oracle's expdp utility provides option to include views while exporting.