RE: RE: Scritp to Generate "Create Table" ??

Jp,

I'll jump in here..

You say you tried the DataBee DBATool? Or did you? It's available here if
not:

http://www.cool-tools.co.uk/Products/dbatool.html

To use DBATool, you need to take a full export from the database, with the
"rows=n" option set - just grab all the DDL structures in other words, and
no data. DBATool will then read this export file, and extract all of the DLL
from it, putting it in to readable format for you.

Navigate to the schema owner that you want to change in the left navigation
pane, find the table in the right pane, and double click it. This will show
you the full DDL for that table, with a number of buttons on the right hand
side - one of these buttons is "Quick Strip", that will strip all storage
clauses from the DDL. You can either use this, for a single DDL statement,
or you can "Add/Update a Rule" from the bottom, which will actually allow
you to strip storage clauses for "All Appropriate Objects" (all tables
within the schema) if you wish.

If you have any specific questions, give me a shout. I know of no *easier*
way than pointing and clicking and having everything done for you ;) And I
know of no other tool that can juggle DDL like DBATool.. :)

HTH

Mark

-----Original Message-----
Khanna J
Sent: 20 June 2003 08:24
To: Multiple recipients of list ORACLE-L


Thanx Ganesh.

tried............EXP/IMP/Databee.
thought of avoiding file copy --> which consumes more time.

.....a script would be more handy , isn't it ?!

Regards,
Jp.

20-06-2003 15:09:33, [EMAIL PROTECTED] wrote:
>Oracle is ready to share it with u ;)
>Use exp and then Imp into a Index file or use the DataBee Tool ..



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).