Re: How to generate script for Oracle 8i on WinNt?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Oct 2000 15:26:54 +0100
Message-ID: <8rcqbe$l8d$1@soap.pipex.net>

Ah then, like the proverbial irishman 'Oi wouldn't be starting from there if oi were you' Export import is the tool for the job.

You *can* produce sql scripts looking at dba_tables,dba_tab_columns,dba_constraints etc but you will almost certainly screw up. I believe that TOAD also has a tool for this purpose.

I do have a java tool for tables and indices which I'll mail the source for if you want, but exp/imp is the way to go.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"news" <whasan99_at_hotmail.com> wrote in message
news:1CKB5.28899$qM3.219289_at_news1.bnapk1.occa.home.com...


> Hi Niall, I want to generate SQL script for the database. so i can run on

> another

>                Oracle server to create a copy of my db.

>

> Thanks

>

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message

> news:8r1ufb$rsh$1_at_soap.pipex.net...

> > Not sure exactly what you mean. Could you expand on what you are trying

 to


> > achieve?

> >

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > "Globalink" <wasiq_at_ibos.com> wrote in message

> > news:01PA5.5480$1I4.336435_at_newsfeed.intelenet.net...

> > > How to generate Tables+ Store procedure  script for Oracle 8i on

 WinNt?


> > >

> > > Thanks

> > > Wasiq Hasan

> > >

> > >

> > >

> >

> >

>

>

Received on Tue Oct 03 2000 - 09:26:54 CDT