Re: How can i generate SQL script?

In article <9c8bin$q31$1_at_news.seed.net.tw>, Ron <ronyin_at_tpts5.seed.net.tw> writes:
>I got just over 500 tables on oracle8.0.5.
>how can i generate SQL script for these tables.
>
>Ron
>

Ron, could you be a little more specific about what kind of script you want to generate; do you want to generate the table DDL or do you want to perform counts of every table, analyzes, etc....?

If you want DDL the quickest way might be to perform a exp with rows=n and then use the indexfile=filename parameter on imp to generate the source code into a text file.

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net