ORACLE table Batch Processing

-- Common oracle system tables
/*
Start with 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
Dba_temp_files temporary data file information
Dba_rollback_segs rollback segment information
Dba_ts_quotas user tablespace quota Information
Dba_free_space idle space information of the database
Dba_profiles database user resource limit information
Dba_sys_privs user's system permission information
Dba_tab_privs object permission information
Column object permission information of dba_col_privs users
Dba_role_privs user's role information
Dba_audit_trail audit trail record information
Dba_stmt_audit_opts audit settings
Dba_audit_object audit result information
Dba_audit_session audit result information
Index information of dba_indexes user mode
Start with user _
User_objects user object information
User_source information of all resource objects of database users
User_segments user's table segment information
User_tables user's table Object Information
Table column information of user_tab_columns
User_constraints object constraint information
User_sys_privs system permission information of the current user
User_tab_privs object permission information of the current user
User_col_privs table column permission information of the current user
User_role_privs role permission information of the current user
User_indexes user index information
Table column information corresponding to the index of user_ind_columns
Table column information corresponding to the constraints of the user_cons_columns user
User_clusters all cluster information of the user
Content of the user_clu_columns user's cluster
User_cluster_hash_expressions information of the hash Cluster
Starting with v $
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
V $ sga database SGA Information
V $ parameter initialization parameter information
V $ process database server process information
V $ bgprocess background process information of the database
V $ controlfile_record_section information of each part of the control file
V $ thread Information
V $ datafile_header information recorded in the Data File Header
V $ archived_log archive log information
V $ archive_dest configuration information for archiving logs
V $ dml ddl result information of logmnr_contents archive log analysis
V $ dictionary file information of logmnr_dictionary Log Analysis
V $ logmnr_logs log list information for 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 SQL statements currently queried and related information
V $ SQL and v $ sqlarea are basically the same related information.
V $ sysstat database system status information
Start with all _
Information of all users in the all_users Database
Information of all objects in the all_objects Database
All_def_audit_opts all default audit settings
All table objects in all_tables
All_indexes information of all database object Indexes
Start with session _
Session_roles session role information
Session_privs session permission information
Start with index _
Index_stats index settings and storage Information
Pseudo table
Dual System pseudo list information
*/

-- Delete a 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 = 'vpmuser' and segment_type = 'table ';

Check whether the table is completely imported
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 '% 201% ')
Minus
Select segment_name from dba_segments where owner = 'vpmuser' and segment_type = 'table' and segment_name not like 'bin $ %'



Author wudeo