Database Software

Hi All,

I am working on this schema refresh project using expdp/impdb with db v.11.

I have wasted enough time (1 full day) on working on couple of issues then finally decide to take help of OTN users and see if we have best and fast way to do it.

Q:
1. I want to generate dynamic drop script to delete tables like '%100%', '%backup%','%ABC%' from user schema but not able to figure out way to do it.. I can do it manually generate 1 drop statement for each table like option but if 50 tables are there then it will take too much manual work which I am trying to ignore?

2. Best way to use EXCLUDE parameter in expdp para file to exclude tables like something like '%100%', '%backup%','%ABC%' : EXCLUDE=table: 'like '%100%', '%backup%','%ABC%''

3. Generate dynamic script for dropping all user objects

4. Stop all db users to access particular schema while import is happening?

5. For consistent export is below parameter right?

flashback_time="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:ss')"


Thanks in advance for looking into my problems.

changed Q.4 from export to import
added Q.5