SQL> create table t1(c1 number primary key
2 using index tablespace users initrans 40 pctfree 10
3 storage(initial 10k next 50k));
Table created.
SQL> select segment_name, tablespace_name
2 from user_segments
3 where segment_name =
4 (select index_name from user_indexes where table_name = 'T1');
SEGMENT_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
SYS_C003077
USERS
SQL> drop table t1;
Table dropped.
SQL> create table t1(c1 number primary key);
Table created.
SQL> select segment_name, tablespace_name
2 from user_segments
3 where segment_name =
4 (select index_name from user_indexes where table_name = 'T1');
SEGMENT_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
SYS_C003078
TEST
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/45259/viewspace-134933/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- How to get server IP address
- 依据统计信息确定多块读被使用
- I'll be there for you
- About storage parameter INITRANS and MAXTRANS
- Instance allocated memory (SGA+PGA)
- PLS-00231 private function is not in scope in SQL
- Fetch limit and %NOTFOUND attribute
- About Merge statement
- Oracle提供的密码复杂度函数
- Enable/disable listener logging
