object_list.sql:
\nset pagesize 0
\nset serveroutput on
\nset linesize 32767
\nset trimspool on
\nset heading on
\nset feedback off
\nset verify off
\nset echo off
\nset long 2000000000<\/p>\n
spool .\\[&_USER.]object_list.csv
\nSELECT ‘OBJECT\u540d’ || ‘,’ || ‘OBJECT\u30bf\u30a4\u30d7’ || ‘,’ || ‘\u72b6\u614b’ FROM DUAL;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘SYNONYM’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘TABLE’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘SEQUENCE’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘VIEW’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘PACKAGE’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘PACKAGE BODY’ ORDER BY OBJECT_NAME;
\nSELECT OBJECT_NAME || ‘,’ || OBJECT_TYPE || ‘,’ || STATUS FROM ALL_OBJECTS WHERE OWNER = ‘&_USER’ AND OBJECT_TYPE = ‘TRIGGER’ ORDER BY OBJECT_NAME;
\nspool off<\/p>\n
spool .\\[&_USER.]table_column_list.csv
\nSELECT ‘\u30c6\u30fc\u30d6\u30eb\u540d’ || ‘,’ || ‘\u5217\u540d’ || ‘,’ || ‘\u30c7\u30fc\u30bf\u578b’ || ‘,’ || ‘\u9577\u3055’ || ‘,’ || ‘\u5c0f\u6570\u90e8’ || ‘,’ || ‘NULL\u53ef’ FROM DUAL;
\nSELECT TABLE_NAME || ‘,’ || COLUMN_NAME || ‘,’ || DATA_TYPE || ‘,’ || NVL(DATA_PRECISION, CHAR_COL_DECL_LENGTH) || ‘,’ || DATA_SCALE || ‘,’ || NULLABLE FROM USER_TAB_COLUMNS ORDER BY TABLE_NAME,COLUMN_NAME;
\nspool off<\/p>\n
spool .\\[&_USER.]index_list.csv
\nSELECT ‘\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u540d’ || ‘,’ || ‘\u5217\u540d’ || ‘,’ || ‘\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30bf\u30a4\u30d7’ || ‘,’ || ‘\u30c6\u30fc\u30d6\u30eb\u540d’ || ‘,’ || ‘UNIQUE\/NONUNIQUE’ || ‘,’ || ‘\u72b6\u614b’ FROM DUAL;
\nSELECT
\nA.INDEX_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\nB.COLUMN_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\nA.INDEX_TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\nA.TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\nA.UNIQUENESS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\n—\u00a0\u00a0\u00a0 A.TABLESPACE_NAME\u00a0\u00a0 || ‘,’ ||
\n—\u00a0\u00a0\u00a0 A.TABLE_OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 || ‘,’ ||
\nA.STATUS
\nFROM
\nUSER_INDEXES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A
\n, USER_IND_COLUMNS\u00a0\u00a0\u00a0 B
\nWHERE
\nA.INDEX_NAME = B.INDEX_NAME
\nORDER BY
\nA.TABLE_NAME
\n, A.UNIQUENESS DESC
\n, B.COLUMN_NAME;
\nspool off<\/p>\n
spool .\\[&_USER.]source.txt
\nSELECT TEXT FROM USER_SOURCE ORDER BY NAME,TYPE,LINE;
\nspool off<\/p>\n
exit<\/p>\n","protected":false},"excerpt":{"rendered":"
object_list.sql: set pagesize 0 set serveroutput on set […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[],"_links":{"self":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/1027"}],"collection":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1027"}],"version-history":[{"count":2,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/1027\/revisions"}],"predecessor-version":[{"id":1029,"href":"https:\/\/vongg.com\/index.php?rest_route=\/wp\/v2\/posts\/1027\/revisions\/1029"}],"wp:attachment":[{"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vongg.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}