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.

Options: ReplyQuote


Subject
Written By
Posted
No schema passed to DBMS_UTILITY.ANALYZE_SCHEMA
May 20, 2005 09:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.