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
5615
June 14, 2006 08:54AM
2499
June 14, 2006 09:04AM
3006
June 14, 2006 09:25AM
2390
June 14, 2006 11:13AM
Re: Equivalent for all_catalog
2748
June 14, 2006 11:22AM
2474
June 14, 2006 11:31AM
2885
June 14, 2006 11:39AM
2668
June 14, 2006 11:52AM
2568
June 14, 2006 02:04PM
2572
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.