Thanks for the question.
Asked: June 24, 2020 - 2:45 pm UTC
Last updated: June 25, 2020 - 1:03 pm UTC
Version: 9.2.0.6.0
Viewed 1000+ times
select tablespace_name from dba_indexes where index_name = :inx;
create table t ( c1 constraint pk primary key ) as select level from dual connect by level <= 100; select de.tablespace_name, ddf.file_id, ddf.file_name from dba_extents de join dba_data_files ddf on de.file_id = ddf.file_id where owner = 'CHRIS' and segment_name = 'PK'; TABLESPACE_NAME FILE_ID FILE_NAME USERS 12 +DATA/DBAAS19C...
Osama, June 29, 2020 - 1:30 pm UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database