Hi,
We need to ensure to backup and save all the content (tables structure, data, indexes, triggers, functions, sequences, constraints, etc.) in a number of Schemas. We used to use imp/exp but in 11g it seems tables without any data blocks were not exports (which seems strange since we nearly lost such tables). I understand data pump does.
So now we are trying to create the syntax to export and import using data pump and shift from the prior exp/imp which was much similar.
Considering to use a user that has EXP_FULL_DATABASE and IMP_FULL_DATABASE roles (as sys)
expdp 'sys/<pwd> as sysdba' DIRECTORY=dpump_dir1 dumpfile=Test.dmp schemas=scott,hr,hprt,twill logfile=testdp.log
The question: to ensure to all schema objects, do I need to add parameters like: CONTENT=ALL INCLUDE=TRIGGER INCLUDE=CONSTRAINT INCLUDE=GRANT INCLUDE=INDEX etc. to the command??
Also what happens if we include some of the INCLUDE, will the others be excluded?
Also we don't need Statistics, but seems there is no way to define this like was in Exp !
To import back:
We usually pre-create the schemas with all the permissions and import back the schema/user.
Appreciate the assistance.
Thanks