Oracle built-in table [SQL] -- Beginning with oracle common system table/* dba ..... dba_users Database User Information dba_segments table segment information dba_extents data zone information dba_objects database object information dba_tablespaces database tablespace information dba_data_files Data File Settings information temporary data file information rollback segment information manual user tablespace quota Information dba_free_space idle space information dba_profiles database user resource restriction information dba_sys_privs user's system permission information dba_tab_privs user's object permission information column object permission information user's role information dba_audit_trail Audit tracking record information audit settings information dba_audit_object Object audit result information dba_audit_session session audit result information dba_indexes user mode index information user_start user_objects user object information user_source database user all resource Object Information user_segments user table segment information user_tables User table Object Information user_tab_columns user's table column information user_constraints user's object constraint information user_sys_privs current user's system permission information user_tab_privs current user's object permission information user_col_privs current user's table column list permission information user_role_privs current user's role permission information user_indexes user's index information user_ind_columns user's index corresponding table column information user_cons_columns user's constraint corresponding table column information user_clusters user's all cluster information user_clu_columns user's cluster information information contained in the user_cluster_hash_expressions hash cluster v $ start with v $ database information v $ datafile data file information v $ controlfile Control File Information v $ logfile redo log information v $ instance database instance information v $ log group information v $ loghist log history information v $ sga database SGA information v $ parameter initialization parameter information v $ process database server process information v $ bgprocess database background process information v $ controlfile_record_section information of each part recorded in the control file v $ thread information v $ information recorded in the datafile_header data file header v $ archived_log archived log information v $ archive_dest archive log setting information v $ dml ddl result information of logmnr_contents archive log analysis v $ dictionary file information of logmnr_dictionary Log Analysis v $ log list information of logmnr_logs Log Analysis v $ tablespace information v $ tempfile temporary file information v $ filestat data file I/O statistics v $ undostat Undo data information v $ rollname online rollback segment information v $ session information v $ transaction information v $ rollstat rollback segment statistics v $ pwfile_users privileged user information v $ sqlarea resources accessed by the currently queried SQL statements and related information v $ SQL and v $ sqlarea are basically the same related information v $ sysstat database system status information all_start all_users all Database User Information all_objects all database object information all_def_audit_opts all default audit settings information all_tables all table Object Information all_indexes all database object Indexes information session _ start with session_roles session role information session_privs session permission information index _ start with index_stats index settings and storage Information pseudo table dual system pseudo list information */-- delete table object select 'drop table '| segment_name from dba_segments where owner = 'vpmuser' and segment_type = 'table '; -- create a table object select 'create table' | segment_name | 'as select * from' | segment_name | '@ dblink' from dba_segments where owner = 'vpentuser' and segment_type = 'table '; check whether the select segment_name from dba_segments @ aaa where owner = 'vpmuser' and segment_type = 'table' and (segment_name not like 'bin $ % 'and segment_name not like' % 100' is fully imported') minus select segment_name from dba_segments where owner = 'vpmuser' and segment_type = 'table' and segment_name not like 'bin $ %'