MySQL Forums
Forum List  »  Oracle

Re: Equivalent for all_catalog
Posted by: Vani Chiganmy
Date: June 14, 2006 11:22AM

I confirmed that these tables are empty:

mysql> select * from A;
Empty set (0.00 sec)

mysql> select * from B;
Empty set (0.00 sec)

Since there are no errors not sure how to debug this issue.
Previously I did create database and executed these commands sucessfully. I dropped this database and recreated database and trying to execute same SQL and it is failing. When we drop database it should drop all data including tables, constraints etc.

Options: ReplyQuote


Subject
Views
Written By
Posted
5531
June 14, 2006 08:54AM
2445
June 14, 2006 09:04AM
2957
June 14, 2006 09:25AM
2342
June 14, 2006 11:13AM
Re: Equivalent for all_catalog
2701
June 14, 2006 11:22AM
2431
June 14, 2006 11:31AM
2834
June 14, 2006 11:39AM
2628
June 14, 2006 11:52AM
2537
June 14, 2006 02:04PM
2537
June 14, 2006 06:12PM


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.