Why is "desc user_constraints" not working in sql/plus but in sql_work?

From: Guang Mei <zlmei_at_hotmail.com>
Date: Tue, 03 Oct 2000 15:00:18 GMT
Message-Id: <10638.118377@fatcity.com>

Hi:

I found something strange today on my NT box. When I run "desc user_constraints" and "desc all_constraints", they worked in "sql worksheet" but not in sqlplus. by the way, they both use the same tnsnames.ora file.

Could anyone explain this to me?

Thanks in advance.

Guang

---

SQL*Plus: Release 8.0.3.0.0 - Production on Tue Oct 3 10:48:37 2000

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SQL> desc user_constraints;
ERROR:
ORA-04043: object user_constraints does not exist

SQL> desc all_constraints;
ERROR:
ORA-04043: object all_constraints does not exist Received on Tue Oct 03 2000 - 10:00:18 CDT