Good day, everyone!
I need do a backup of only tables and their triggers and sequence. But I can't find the right way. I looked at the parameters of exp utility, but I only found the TRIGGER parameter. But I couldn't find a parameter to include sequence and exclude procedures, function, and package.
I found query parameter, so maybe where
statement can help me, but I don't understand how it work, because cos where statement is superimposed on all tables.
How can I export only tables, sequence, and triggers of a schema?
I looked here, but didn't found a solution.
The old 'exp' utility does provide many options and can get you backup of tables and triggers ONLY (not sequence or any other type objects).
Pls use advanced 'expdp' (data pump) for better options. You can use 'INCLUDE or EXCLUDE' object switch to meet your goal.
Pls check out for more details...
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#IncludeExclude