|
-
Yes!
PNXTL02-> select object_name , object_type , owner from dba_objects where object_name='MPUSNTAB';
Object Type Owner
------------------------------ --------------- ------------
MPUSNTAB SYNONYM PUBLIC
MPUSNTAB TABLE SYSADM
MPUSNTAB SYNONYM BSC
MPUSNTAB SYNONYM SISTEMA_VIEWER
MPUSNTAB SYNONYM BSCUSR
The table .....
CREATE TABLE mpusntab
(sncode NUMBER NOT NULL,
rec_version NUMBER NOT NULL,
des VARCHAR2(30),
shdes VARCHAR2(5),
snind VARCHAR2(1)
,
PRIMARY KEY (sncode)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE rtx_data
STORAGE (
INITIAL 40960
NEXT 40960
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 505
))
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE bscs_data
STORAGE (
INITIAL 40960
NEXT 40960
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
)
/
Last edited by hhbrazil; 10-31-2003 at 04:13 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|