eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MDSYS.MD$PTAB

Object Details

Object Name:	MD$PTAB
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: MD5

PNAME
OWNER

Indexes

Index	Type	Uniqueness	Tablespace	Column
MD5	NORMAL	UNIQUE	SYSTEM	PNAME OWNER

Foreign Keys

Table		Foreign Table	Foreign Key Column
MD$PTAB		MD$TAB	MD$PTAB OWNER MD$PTAB MDTNAME

Columns

Name	Datatype	Length	Mandatory
OWNER	VARCHAR2	(30)	Yes
MDTNAME	VARCHAR2	(30)
PNAME	VARCHAR2	(30)	Yes
CLASS	NUMBER
CCLV	NUMBER
CCHH	RAW	(255)
OLST	NUMBER	(1)
ARCHD	DATE
MAX_CC	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      MDTNAME
,      PNAME
,      CLASS
,      CCLV
,      CCHH
,      OLST
,      ARCHD
,      MAX_CC
FROM MDSYS.MD$PTAB;

Dependencies

[top of page]

MDSYS.MD$PTAB does not reference any database object

MDSYS.MD$PTAB is referenced by following:

MDSYS: ALL_MD_PARTITIONS; DBA_MD_PARTITIONS; USER_MD_PARTITIONS