Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Ravi.

Asked: July 07, 2016 - 11:17 am UTC

Last updated: July 08, 2016 - 5:48 am UTC

Version: 11.2

Viewed 1000+ times

You Asked

Hi Tom,

Following are the scenarios and please let me know what will happen in the listed scenarios :

1. I have a Undo table space with least size, i do a deleting of records in a table which is huge in size(a size which undo tablespace can not handle at one shot). (a)How do undo table space will handle this scenario (b)in case of recovery from an abnormal shutdown?

2. I do have a Temp table space of size say 1 GB(no auto extent on), and i do an import of a table with size 2 GB. Whether import will be successful, if yes, how?


Regards
P.B.Ravi Kumar

and Connor said...

1a) if the you cant get enough undo (eg autoextend off etc), then you'll get an error (unable to extend tablespace), and your delete will roll back

1b) if during the delete the database dies, then on restart, the redo logs will resurrect the undo information, and then that undo information can be used to rollback the incomplete transaction

2) You dont need temp space to import table data. However, your import might also be creating indexes, and they *might* need temporary space. So the likely results are either:

- your table and indexes get imported succesfully, or
- your table imports successfully, but your index fails to be created

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Ravi Kumar, July 08, 2016 - 6:49 am UTC

thanks fo the explanation

regards
P.B.Ravi Kumar