Forum Stats

  • 3,872,010 Users
  • 2,266,363 Discussions
  • 7,911,026 Comments

Discussions

Verify Storage Grants On Creating Table

Matheus Boesing
Matheus Boesing Member Posts: 46 Blue Ribbon
edited Jul 14, 2016 10:53AM in Database Ideas - Ideas

After 11.2 and Deffered Segment Creation, it's possible to create a table without errors and only when inserting have a permission error.

It's common when installing a new application or application's feature in a datababase, only create the new objects. So, the grants will be validated when application will be really used for production objectives, generating error and incidents.

What if, when creating an object with deffered segment creation, the permissions in the tablespace be validated? (Just validate, not really allocate segments)

The deffered segment creation is pretty good feature, but left this gap...

This post explain the situation: https://grepora.com/2016/07/13/ora-01950-on-insert-but-not-on-create-table/

Matheus BoesingBPeaslandDBAWilliam Robertsonctrieb
4 votes

Active · Last Updated