Re: How to do...

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 19 Dec 2001 14:07:50 GMT
Message-ID: <Wa1U7.7676$Ah.445891@rwcrnsc52>

"MqBen" <mqben_at_aol.com> wrote in message news:20011219014648.14751.00000598_at_mb-bj.aol.com...
> 1.How to do to know all the schema that a user can see in a database after
his
> login?
>
> 2. How to do to know all the tables that he can see?
>

select table_name from all_tables;

> 3. How to do to know indexes build on a table?
>

select * from dba_index where table_name='XXX'
> 4. How to retrieve the script of creation of a table?
>

An easy way is to export the table then do an import but data=no and indexfile=filename

> And all things with sql command....

? Haven't a clue what you mean here.
>
> If you have any idea....thanks for your attention.

You best bet is to look in the documentation. Specifically the utilities for export, import, the sql reference for information on sql commands, and the oracle server reference for the catalog information. You should have gotten it when you installed the software or go to www.otn.oracle.com and choose documentation.
Jim Received on Wed Dec 19 2001 - 08:07:50 CST