Re: newbie question - oracle schema

I hate to be so persistent and appear so dumb, it is probably because I have spent a year working on a Sybase Db.

Export from Personal 8 doesn't give any options other than where to put the dump file. The file it dumps is not a pure text file. There are no other programs to export provided on the Personal 8 CD. Are there any other Oracle tools available to perform the dump?

Thanks in advance.

Dave
AJ Allen <aallen20_at_ford.com> wrote in message news:38C928CB.319612BE_at_ford.com...
> Dave Larkins wrote:
> >
> > I was actually referring to the process of extracting the schema in a
pure
> > text form and reloading a modified form. Export/Import don't produce
pure
> > text, is there anything that does?
> >
> > BTW notepad has a filesize limitation that will probably make it
impractical
> > to use for this purpose.
> >
> > Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> > news:952696494.17922.0.pluto.d4ee154e_at_news.demon.nl...
> > >
> > > Dave Larkins <davidl_at_mint.net> wrote in message
> > > news:8aau44$gi6$1_at_ruby.mint.net...
> > > > Hello all,
> > > >
> > > > Are there any tool for working on an oracle database schema in a
textual
> > > > form? I have just installed Oracle Personal 8 on Win 98 to get
acqainted
> > > and
> > > > don't find anything that will let me create and edit schema offline
and
> > > load
> > > > into the Db.
> > > >
> > > > thanks Dave
> > > >
> > > >
> > > >
> > > What about Notepad?
> > >
> Export without the data will give you a text file of all the ddl
> statements.
>
> I use EditPad. It is postcardware that seems to have an unlimited file
> size and
> uses the tab construct so switching between various open files is easy.
> You can
> find EditPad at www.jgsoft.com.
>
> --
> *--------------*-----------------------------------------------*
> | Andrew Allen | DBA |
> | | Process Leadership / PSL, Dearborn, MI USA |
> * Definitions: *-----------------------------------------------*
> |Science : Looking for a black cat in a dark room. |
> |Philosophy : Looking for a black cat in a dark room where |
> | there is no cat. |
> |Psycho Analysis: Looking for a black cat in a dark room where |
> | there is no cat and finding one anyway |
> *--------------------------------------------------------------*
Received on Fri Mar 10 2000 - 16:12:25 CST