CODEWITHSUNDEEP
oracle-database
Victor
Victor

Reputation: 17107

How does oracle estimate the space required for a bulk insert

When I do a bulk insert in an oracle db, (e.g 1 million rows), before starting the insert ,does oracle calculate how much space is required for the new rows and somehow 'block' that space so no other process can insert anything in that space?

Upvotes: 3

Views: 141

Answers (2)

Srini V
Srini V

Reputation: 11375

Answer discussed by ASKTOM: A Must Read

Upvotes: 0

HAL 9000
HAL 9000

Reputation: 3985

No. You'll run into ORA-01653: unable to extend table xxx by yyy in tablespace zzz

You'd have to compute this manually and create large enough initial and/or next extents using the storage clause.

Refer to the Oracle documentation of Conventional and Direct Path Loads

Upvotes: 0

Related Questions