Skip to Main Content



Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer

Connor McDonald

Thanks for the question, Ravi.

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

Answered by: Connor McDonald - Last updated: July 08, 2016 - 5:48 am UTC

Category: Database - Version: 11.2

Viewed 100+ times

Whilst you are here, check out some content from the AskTom team: Reflections on Oracle Open World 2015

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?

P.B.Ravi Kumar

and we 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.

and you rated our response

  (1 rating)

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


July 08, 2016 - 6:49 am UTC

Reviewer: Ravi Kumar

thanks fo the explanation

P.B.Ravi Kumar