Database Administration (MOSC)

MOSC Banner

Remove/Delete all things(all objects) after import action into Oracle19c

---------------------------------------------------

We are doing migration works from oracle 11g to Oracle 19c.

1. First export a schema from source DB

2. Create sql script for - table spaces , users ..etc from source db

3. I ran the script into target database

4. Finally I import the dump into target DB and import successfully done with some error, I attached the file.

5. Now we are mock import running , So I want to do the above steps for several times . So Now I need to remove all things done what completed in step 4. How I will remove all items created in step-4 , Then I will run further import action.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center