How to know constraints,indexes,sequences without reading data dictionary?

Posted by Vineet on Stack Overflow See other posts from Stack Overflow or by Vineet
Published on 2010-03-14T05:25:22Z Indexed on 2010/03/14 5:35 UTC
Read the original article Hit count: 143

Filed under:

oracle9i

I want to show indexes,sequences,constraints in DESC command ,is it possible, or any other cammand by which i can see structure(design) of a table along with constraints, sequences,indexes.

Related posts about oracle9i

Oracle9i export error

as seen on Server Fault - Search for 'Server Fault'
When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully what should i do to resolve… >>> More
migrating from mysql to oracle9i.Equivalent create table syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql. I want to create table with same properties in oracle9i. Can anyone provide me the equivalent syntax for oracle? CREATE TABLE IF NOT EXISTS "tbl_audit_trail" ( "id" int(11) unsigned NOT NULL, "old_value" text NOT NULL, … >>> More
how query a cube olap using a java Application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap. thanks for your help >>> More
Oracle 9i Session Disconnections

as seen on Server Fault - Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections. We got this box set up by our IT department and handed over to. It is 'our problem', so options… >>> More
Linked SQL Server to Oracle

as seen on Server Fault - Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider… >>> More

Developer IT

How to know constraints,indexes,sequences without reading data dictionary? - Developer IT

How to know constraints,indexes,sequences without reading data dictionary?

oracle9i

Related posts about oracle9i

Oracle9i export error

migrating from mysql to oracle9i.Equivalent create table syntax

how query a cube olap using a java Application

Oracle 9i Session Disconnections

Linked SQL Server to Oracle

Categories cloud