Timeline for What is the default quota on a tablespace for a given user in oracle if you don't set one?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 6, 2019 at 15:02 | comment | added | Adrián Jaramillo | so when you actually do have quota on a tablespace and you store data on it, segments are created for each object IN the tablespace? @BalazsPapp | |
| Dec 6, 2019 at 14:50 | comment | added | Balazs Papp |
@AdriánJaramillo If you created a table like above, you could find its metadata in views such as DBA_TABLES, DBA_TAB_COLS, etc. At that point the segment for the object was not created, so there was no quota requirement and it would not show up in DBA_SEGMENTS. You can create a table like above even in a read-only tablespace. This may be confusing, but the point is to know about the feature called deferred segment creation.
|
|
| Dec 6, 2019 at 14:44 | comment | added | Adrián Jaramillo | so is there a way to query all metadata of the objects that a user has created, but is not actually stored in its default tablespace? For example, since I have created that table, I want a way for looking that information before it's stored in the tablespace, if for example in the future I assign it a real quota @BalazsPapp | |
| Dec 6, 2019 at 14:41 | comment | added | Balazs Papp |
@AdriánJaramillo The metadata is stored in the dictionary tables such as SYS.OBJ$. There was no seperate segment created for this object just for metadata.
|
|
| Dec 6, 2019 at 14:30 | comment | added | Adrián Jaramillo | How can I find the segment that was created for that user to store the metada of the table? Where is the location of the real files where segments are stored? @BalazsPapp | |
| Dec 6, 2019 at 9:46 | vote | accept | Adrián Jaramillo | ||
| Dec 5, 2019 at 21:50 | history | answered | Balazs Papp | CC BY-SA 4.0 |