DBA Hub

📋Steps in this guide1/1

Find the table partition keys

--- describes the partitioning key columns for all partitioned objects of a schema

oracle configurationintermediate
by OracleDba
11 views
1

Find the table partition keys

--- describes the partitioning key columns for all partitioned objects of a schema

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
set pagesize 200
set lines 200
set long 999
col owner for a12
col name for a20
col object_type for a20
col column_name for a32
SELECT owner, NAME, OBJECT_TYPE,column_name
FROM dba_part_key_columns where owner='&OWNER'
ORDER BY owner, NAME;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!