컴퓨터활용/오라클

oracle user

멜번초이 2003. 10. 12. 00:16
반응형
SQL> desc dba_users;
이름                                      널?      유형
----------------------------------------- -------- --------------
USERNAME                              NOT NULL VARCHAR2(30)
USER_ID                                   NOT NULL NUMBER
PASSWORD                                               VARCHAR2(30)
ACCOUNT_STATUS                   NOT NULL VARCHAR2(32)
LOCK_DATE                                              DATE
EXPIRY_DATE                                            DATE
DEFAULT_TABLESPACE            NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE       NOT NULL VARCHAR2(30)
CREATED                                 NOT NULL DATE
PROFILE                                   NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP             VARCHAR2(30)
EXTERNAL_NAME                                      VARCHAR2(4000)
반응형

'컴퓨터활용 > 오라클' 카테고리의 다른 글

clob 컬럼 데이타 조회하기  (0) 2005.10.12
v$session  (0) 2003.10.12
오라클 유저 생성  (0) 2003.10.12
oracle listener status check  (0) 2003.10.12
ORACLE export / import 예제  (0) 2003.10.12