Re: how to extract create table scripts from datadictionary views?

With Oracle7, user_tables gives you the storage informations (tablespace, cluster, pct_free, pct_used, int_trans, ...) and user_tab_columns informations on the columns (name, type, ...).

In Oracle8, you have to add the informations on partitions with user_tab_partitions, user_ind_partitions, user_part_key_columns.

If you want also constraints you have to watch to user_constraints, user_cons_columns, user_indexes (for storage informations on the indexes associated to the primary key, ...).

If you want also indexes: user_indexes, user_ind_columns.

... (synonyms, privileges, cluster, ...)

--
Have a nice day
Michel

Chroma <test_at_chromazone.demon.nl> a écrit dans le message : 941540763.23203.0.pluto.d4ee2f03_at_news.demon.nl...
> Can anyone tell me, how to extract CREATE TABLE scripts for all user tables
> from the Oracle datadictionary views?
>
> Thanx,
>
> Martijn
>
>
Received on Tue Nov 02 1999 - 07:28:12 CST