Thanks for the question.
Asked: June 24, 2020 - 2:45 pm UTC
Answered by: Chris Saxon - Last updated: June 25, 2020 - 1:03 pm UTC
Category: Database Administration - Version: 188.8.131.52.0
Viewed 100+ times
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...
June 29, 2020 - 1:30 pm UTC
Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.
Need more information on Administration? Check out the Administrators guide for the Oracle Database