1、得到一个用户下的所有表,索引,存储过程,函数的ddl SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name) FROM USER_OBJECTS u where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE','FUNCTION‘); 2、得到所有表空间的ddl语句 SELECT DBMS_METADATA.GET_DDL('TABLESPACE', TS.tablespace_name)...
SELECT DBMS_METADATA.GET_DDL('PROCOBJ', D.JOB_NAME, D.OWNER) FROM DBA_SCHEDULER_JOBS D WHERE D.JOB_TYPE = 'STORED_PROCEDURE' AND D.STATE = 'SCHEDULED' AND D.SCHEDULE_NAME IS NULL; n 得到一个用户下的所有表、索引、存储过程、函数的DDL语句: SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE...
REFRESH MATERIALIZED VIEW RESET REVOKE Nutzungshinweise Beispiele ROLLBACK SELECT WITH-Klausel SELECT-Liste FROM-Klausel Beispiele für PIVOT und UNPIVOT JOIN-Beispiele WHERE-Klausel Externe Joins nach Oracle in der WHERE-Klausel GROUP BY-Klausel Aggregationserweiterungen HAVING-Klausel QUALIFY-Klausel...
System view mapping for migrating to SYS monitoring views System monitoring (provisioned only) STL views for logging STL_AGGR STL_ALERT_EVENT_LOG STL_ANALYZE STL_ANALYZE_COMPRESSION STL_BCAST STL_COMMIT_STATS STL_CONNECTION_LOG STL_DDLTEXT STL_DELETE STL_DISK_FULL_DIAG STL_DIST STL_ERROR STL_...
创建cursor来收集对象的所有者、类型和名称，将ddl For cursor循环嵌套在显式cursor循环中，并使用replace...
Incorrect or inconsistent handling of the warehouse ID in various methods, especially when modifying common job properties and managing task slots. You can modify the code like this: private void modifyCommonJobProperties(Map<String, String> jobProperties) throws DdlException { // Some properties wil...
If the Oracle8i/9i database instance is inactive, Warehouse Builder will display a connection error message. The Warehouse Builder console opens and displays the contents of the repository in the navigation tree. If this is a newly created repository, the default project MY_PROJECT displays. Figur...
STL_DDLTEXT STL_DELETE STL_DISK_FULL_DIAG STL_DIST STL_ERROR STL_EXPLAIN STL_FILE_SCAN STL_HASH STL_HASHJOIN STL_INSERT STL_LIMIT STL_LOAD_COMMITS STL_LOAD_ERRORS STL_LOADERROR_DETAIL STL_MERGE STL_MERGEJOIN STL_MV_ STATE STL_NESTLOOP STL_PARSE STL_PLAN_INFO STL_PROJECT STL_QUERY STL...