Re: newbie question - oracle schema

I can give two answers to your question First (and I hate to do this, but sometimes it is really necessary) The first release of Oracle was in 79, it is not the typical Windows toy, so RTFM, RTFM, RTFM
(sorry).
Oracle is not a product where you can just blow away, follow no courses etc. I don't intend to flame, I only just got a bit annoyed

I doubt whether there is only one option, usually they put the other options under advanced
(I will refrain from further comments here) Secondly, import is capable of generating a textfile from the binary export. The commandline for this is
either
imp80 <username/password>@database file=<name of export file> show=y log=<any filename>
or
imp80 <username/password>@database file=<name of export file> indexfile=<any filename>
This definitely should be available from the GUI version, or they have changed the complete product since 7 (which is very unlikely) For a more detailed description of exp and imp refer to the Oracle Server Utilities Manual.

Hth,

Sybrand Bakker, Oracle DBA

Dave Larkins <davidl_at_mint.net> wrote in message news:8abru0$v5u$1_at_ruby.mint.net...
> 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:21:00 CST