如果您无法下载资料，请参考说明：
1、部分资料下载需要金币，请确保您的账户上有足够的金币
2、已购买过的文档，再次下载不重复扣费
3、资料包下载后请先用软件解压，在使用对应软件打开
数据库校验脚本--1.DATABASELINKselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_type='DATABASELINK'orderbyobject_type,object_name,x.subobject_name;--2.TABLESPACEselecttablespace_name,status,contents,loggingfromdba_tablespacesorderbytablespace_name;--3.PROCEDUREselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_type='PROCEDURE'orderbyobject_type,object_name,x.subobject_name;--4.Package&PackageBodyselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_typein('PACKAGE','PACKAGEBODY')orderbyobject_type,object_name,x.subobject_name;--5.TRIGGERselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_type='TRIGGER'orderbyobject_type,object_name,x.subobject_name;SELECTOWNER,trigger_name,statusFROMdba_triggersWHEREOWNER='BLS';--6.JOBSELECTJOB,LOG_USER,PRIV_USER,SCHEMA_USER,NEXT_DATE,NEXT_SEC,BROKENFROMDBA_JOBS;------------------------------------------7.TABLEselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_type='TABLE'orderbyobject_type,object_name,x.subobject_name;selectowner,tablespace_name,table_name,num_rows,partitionedfromdba_tableswhereowner='BLS'orderbytablespace_name,table_name;selecttable_name,partition_name,partition_position,tablespace_name,num_rowsfromdba_tab_partitionswheretable_owner='BLS'orderbytable_name,partition_name;selectconstraint_name,table_name,statusfromuser_constraintswhereconstraint_type='P'orderbytable_name;--8.INDEXselectx.object_name,x.subobject_name,x.object_type,x.status,x.temporary,x.generated,x.secondaryfromuser_objectsxwherex.object_type='INDEX'orderbyobject_type,object_name,x.subobject_name;selecttable_name,index_name,index_type,tablespace_name,status,n
立即下载
