Technical Development - Tiveloper.

To obtain the names of all of your tables, you can use the USER_TABLES.DESCRIBE user_tables; Name Null? Type TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME VARCHAR2(30) IOT_NAME VARCHAR2(30) STATUS VARCHAR2(8) PCT_FREE NUMBER PCT_USED NUMBER SELECT table_name FROM user_tables;TABLE_NAME DEPT EMPLOYEES2 REGIONS LOCATIONS DEPARTMENTS JOBS EMPLOYEES JOB_HISTORY JOB_GRADE..

To obtain the names of all of your tables, you can use the USER_TABLES.DESCRIBE user_tables; Name Null? Type TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME VARCHAR2(30) IOT_NAME VARCHAR2(30) STATUS VARCHAR2(8) PCT_FREE NUMBER PCT_USED NUMBER SELECT table_name FROM user_tables;TABLE_NAME DEPT EMPLOYEES2 REGIONS LOCATIONS DEPARTMENTS JOBS EMPLOYEES JOB_HISTORY JOB_GRADE..

DESCRIBE DICTIONARY;Name Null? Type TABLE_NAME VARCHAR2(30) COMMENTS VARCHAR2(4000) SELECT * FROM dictionary WHERE table_name = 'USER_OBJECT' COMMENTS USER_OBJECTS Objects owned by the user The Dictionary view contains the name and short description of each dictionary view to which you have access. From the dictionary view, you can find what kinds of views are in the Oracle database. The names i..

DESCRIBE DICTIONARY;Name Null? Type TABLE_NAME VARCHAR2(30) COMMENTS VARCHAR2(4000) SELECT * FROM dictionary WHERE table_name = 'USER_OBJECT' COMMENTS USER_OBJECTS Objects owned by the user The Dictionary view contains the name and short description of each dictionary view to which you have access. From the dictionary view, you can find what kinds of views are in the Oracle database. The names i..

Oracle Server : Consist of base tables and user-accessible views. - Several views that summarized and display the information stored in the base tables of the data dictionary. - Most user cannot access to the base tables. - The Oracle user SYS owns all base tables and user-accessible views of the data dictionary. View naming convention : - User : User's view (what is in your schema; what you own..

Oracle Server : Consist of base tables and user-accessible views. - Several views that summarized and display the information stored in the base tables of the data dictionary. - Most user cannot access to the base tables. - The Oracle user SYS owns all base tables and user-accessible views of the data dictionary. View naming convention : - User : User's view (what is in your schema; what you own..

A collection, data dictionary, is created and maintained by the Oracle server and contains information about the database. The basic structure is alike the other database data. Use SQL statement to access the data dictionary.(Read Only) Normarlly, users cannot access to the data dictionary table directly. They are only allowed to access to the view of the data dictionary. What can a user find fr..

A collection, data dictionary, is created and maintained by the Oracle server and contains information about the database. The basic structure is alike the other database data. Use SQL statement to access the data dictionary.(Read Only) Normarlly, users cannot access to the data dictionary table directly. They are only allowed to access to the view of the data dictionary. What can a user find fr..

내가 기억하기로는 내가 분명히 view를 생성했던걸로 기억하는데,, 권한이 없다니..아마도 예전 윈도우 서버에서 했던게 기억나서 그랬나 보다. 아마도 그때에는 연습용 유저 생성시 권한 설정을 이번이랑 다르게 했었나봐...ㅋㅋㅋ 암튼 권한이 없다면서 ora-01031: insufficient privileges 이런 에러를 보여주는군..ㅋㅋㅋ 고민하다가 생각해낸 아주 쉬운 해결책..ㅋㅋㅋ GRANT connect, resource, dba to user_name; 어때 아주 간단하지? ㅋㅋㅋ

내가 기억하기로는 내가 분명히 view를 생성했던걸로 기억하는데,, 권한이 없다니..아마도 예전 윈도우 서버에서 했던게 기억나서 그랬나 보다. 아마도 그때에는 연습용 유저 생성시 권한 설정을 이번이랑 다르게 했었나봐...ㅋㅋㅋ 암튼 권한이 없다면서 ora-01031: insufficient privileges 이런 에러를 보여주는군..ㅋㅋㅋ 고민하다가 생각해낸 아주 쉬운 해결책..ㅋㅋㅋ GRANT connect, resource, dba to user_name; 어때 아주 간단하지? ㅋㅋㅋ