Re: Scritp to Generate Create Table ??

2003-06-23 Thread Prem Khanna J
Hi Rex, Thanx a lot for your script. let me modify it and give a try. Regards, Jp. 20-6-2003 21:43:39, Rex Cluff [EMAIL PROTECTED] wrote: Hi Prem, I have a script that you will probably have to modify - and it may not be bullet proof either - so I offer it without any guarantees. If you

Scritp to Generate Create Table ??

2003-06-20 Thread Prem Khanna J
Guys, I would to generate Create Table .. script for a schema WITHOUT storage parameters. Can someone share a script for the same ?! ENV is 8.1.6/Win2K. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City

Re: RE: Scritp to Generate Create Table ??

2003-06-20 Thread Prem Khanna J
Thanx Ganesh. triedEXP/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

Re: Scritp to Generate Create Table ??

2003-06-20 Thread Prem Khanna J
Thanx a lot Sanjiv Ganesh. Got the script from Mudhalvan. Regards, Jp. -- 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--

RE: RE: Scritp to Generate Create Table ??

2003-06-20 Thread Mark Leith
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

Thanks -- RE: Scritp to Generate Create Table ??

2003-06-20 Thread Prem Khanna J
Thanks a lot Mark. Jp. 20-06-2003 18:54:18, "Mark Leith" [EMAIL PROTECTED] wrote: Jp, I'll jump in here.. You say you tried the DataBee DBATool? Or did you? It's available here if not: -- Please see the official ORACLE-L FAQ:

Re: Thanks -- RE: Scritp to Generate Create Table ??

2003-06-20 Thread Mladen Gogala
Of course, there is always dbms_metadata, so that you don't have to use any utilities. On 2003.06.20 08:11, Prem Khanna J wrote: Thanks a lot Mark. Jp. 20-06-2003 18:54:18, Mark Leith [EMAIL PROTECTED] wrote: Jp, I'll jump in here.. You say you tried the DataBee DBATool? Or did you? It's