CODEWITHSUNDEEP
sqloracle-databaseddl
Daniel Horvath
Daniel Horvath

Reputation: 359

Alter Segment created

I'm doing:

ALTER TABLE WG106_STAGE ALLOCATE EXTENT;

to change Segment created yes to YES from NO.

The value is changed, but after some time it's back to Segment created no

It is not an fix operation?

I'm running on that table an INSERT or UPDATE and after that TRUNCATE table WG106_STAGE drop all storage every 10 minutes.

Upvotes: 1

Views: 370

Answers (1)

Daniel Horvath
Daniel Horvath

Reputation: 359

I assume, that when the table is empty, than the parameter 'Segment created' is automatically changed to NO. As this was my first question it can be closed, because to say true, it wasn't established as needed.

Upvotes: 1

Related Questions