Following steps will flush all the data .

1. Create a new temporary tablespace (with the different name e.g. tmp_temp) in the database

2. Now alter all users to use that temporary tablespace (tmp_temp). Use ALTER USER statement.

3. Now drop the earlier temporary tablesapace.

4. Now recreate the temporary tablespace with same name as step 3.
5. Now alter all users to use temporary tablespace. Use ALTER USER statement.

No comments:

Post a Comment

Have something to say? Don't hold it, post a comment

Interesting Posts.....

Loading...