oracle table

Oracle Table의 종류

 

Data Dictionary : 테이블에 대한 정보 저장

                              ex) select  *  from dict;

      

                                     connect  sys/change_on_install  as  sysdba

                                     show  user;

                                     select  *  from dict;

                                     desc  dba_users

                                     select  username,password  from  dba_users;

      

                            : 접두사 + 관심keyword + 복수형

                              -> USER_ :내가 생성한 것과 관련된 정보

                                               ex)  desc  user_tables;

                                                      select  table_name  from  user_tables;

                              -> ALL_    :접근 권항이 있는 것과 관련된 정보

                                                ex)  desc  all_tables;

                                                       select  table_name,owner  from  all_tables;

                              -> DBA_    :관리자만 접근해야하는 것과 관련된 정보

                            

                              -> V$         : 동적,성능 (동적메모리....)

                                   

User  Table