No schema passed to DBMS_UTILITY.ANALYZE_SCHEMA
Posted by:
kk_us
Date: May 20, 2005 09:59AM
After I went through reverse engineering, migration tool showed me no table has been selected. I am using 1.0.6 beta for mySQL 4.1 in windows xp pro, oracle 9.2, jdk1.4.2. Following is the script from clicking advance button. It seems no schema was passed to DBMS_UTILITY.ANALYZE_SCHEMA. Any clue?
-----------------------------------------------------------------------
Initializing JDBC driver.
Driver class oracle.jdbc.OracleDriver
Opening connection.
Connection jdbc:oracle:thin:myacct/mypwd@10.30.1.20:1521:myhoststring
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for myschema.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?, 'ESTIMATE', 50, 0, 'FOR TABLE')
Fetch the number of tables in the schema myschema.
SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetching 0 table(s) of the schema myschema.
SELECT * FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetch all views of the schema myschema.
SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER=? AND c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V'ORDER BY v.OWNER, v.VIEW_NAME
Views fetched.
Fetch count of stored procedures of the schema myschema.
SELECT COUNT(*) AS NUM FROM ALL_PROCEDURES p WHERE p.OWNER=? ORDER BY p.OBJECT_NAME
Fetching 0 stored procedure(s) of the schema myschema.
SELECT p.*, (SELECT max(s.TYPE) FROM ALL_SOURCE s WHERE s.OWNER=? AND s.NAME=p.OBJECT_NAME) as TYPE FROM ALL_PROCEDURES p WHERE p.OWNER=? ORDER BY p.OBJECT_NAME
SELECT TEXT FROM ALL_SOURCE WHERE OWNER=? AND NAME=? ORDER BY LINE
Stored procedures fetched.
Fetch the number sequences of the schema myschema.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 0 sequence(s) of the schema myschema.
SELECT SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, INCREMENT_BY, CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE, LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Sequences fetched.