-
编辑 删除
Grant general user login EM
SQL> grant select_catalog_role to scott;
-
编辑 删除
手工 RAC Archive , flashback
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+WEBLOG/' SCOPE=SPFILE SID='*';ORALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' SCOPE=SPFILE SID='*';ALTER SYSTEM SET CLUSTER_D...
-
编辑 删除
TTS (PT)
Before: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 After: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 PTS1 TTS to NewDB. Action: create ...
-
编辑 删除
LogMiner
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_4_4qmyvk67_.arc',dbms_logmnr.new);execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_3_4qmyq1bl_.arc',dbms_logmnr.addfile);execute DBMS_LOGMNR.ADD_LOGFILE ('/....
-
编辑 删除
PT_IOT test
CREATE TABLE BENCHMARK.H_ORDER_IOT_PA( O_ORDERKEY NUMBER NOT NULL, O_CUSTKEY NUMBER...
-
编辑 删除
PT test
CREATE TABLE BENCHMARK.H_ORDER_PA( O_ORDERKEY NUMBER PRIMARY KEY NOT NULL, O_CUSTKEY  ...
-
编辑 删除
IOT test
SELECT * FROM h_order WHERE O_orderdate > TO_DATE ('1998-1-1', 'YYYY-MM-DD')ORDER BY o_orderdate; CREATE ...
-
编辑 删除
dbms_redefinition
Note: DBMS_REDEFINITION is used to redefine table columns and column names. Tables that can not be redefined are: Tables that have materialized views and materialized view logs defined on them ...
