Refresh schemas on DEV

[wchuacs]

Hi,

We have same databases one for Production and the other is our Development. There is a need to once a while refresh our Development schemas to have the most current data. My questions are:
1) besides export/import, what else methods can be used?
2) what options required when doing EXP, like CONSTRAINTS, INDEX....can give one example here ?
3) and the same goes to IMP...example please !
4) besides invalid and total objects importing, what else need to take care after the import? eg: missing synonyms?
5) and finally what else more do I miss out ?

thanks in advanced...

 

[Scunningham99]

YOU CAN PLUG IN A TABLESPACE FROM ANOTHER DATABASE transport_tablespace='TABLESPACE NAME'

THIS SAVES YOU TIME HAVING TO IMPORT EXPORT.

EXAMPLE IMP/EXP.

EXP USERID=SYS/MANAGER TABLESPACE=(AP,GL,FA) DIRECT=Y

YOU DO NOT NEED TO INCLUDE GRANTS, INDEXES ETC AS THEY ALL DEFAULT TO 'Y' ANYWAY!

IMP USERID=SYS/MANAGER FROMUSER=(AP,GL,FA) TOUSER(AP,GL,FA)


WHY DONT YOU DO A DATAFILE REFRESH!! FROM PROD TO DEV.
USERS ARE CREATED FOR YOU IN THE NEW DATABASE (IF THEY ARE NOT THERE ALREADY) THE ONLY THING THAT IS NOT IMPORTED IS PRIVALAGES.



Sy UK