Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does Oracle determine the tablespace and the storage parameters for objects to be created?

April 26, 2017determine objects Oracle parameters storage tablespace

0

Posted

How does Oracle determine the tablespace and the storage parameters for objects to be created?

1 Answer

0

Posted

Generally, SAP explicitly specifies tablespaces and storage parameters. These values then undergo a 1:1 conversion by Oracle. If tablespaces and storage parameters are not explicitly specified, Oracle proceeds according to the following rules: If a tablespace is not specified for tables or indexes, the object is created in the default tablespace of the database user who is logged on to the system. You can determine the default tablespaces for the database users as follows: SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS; If the tablespace specification is missing for partitions, the default setting is used for the partition. You can determine this for tables or indexes as follows: SELECT DEF_TABLESPACE_NAME FROM DBA_PART_TABLES WHERE TABLE_NAME = ‘‘; SELECT DEF_TABLESPACE_NAME FROM DBA_PART_INDEXES WHERE INDEX_NAME = ‘‘; Oracle determines non-specified storage parameters for tables or indexes from the default values of the relevant tablespaces. You can determ