Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Datamanagment/EXPORT

Re: Datamanagment/EXPORT

From: koert54 <koert54_at_nospam.com>
Date: Tue, 19 Mar 2002 19:07:34 GMT
Message-ID: <W%Ll8.18665$DE4.2380@afrodite.telenet-ops.be>


> But that's simply not
> true -as a hardened Windows user and Unix-hater, I love a good GUI

Howard - you're kidding right ? :-)

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a780ql$2e7$1_at_lust.ihug.co.nz...
> Don't take this the wrong way, but if you are rather new to Oracle, it
pays
> to learn it at the command line first, and only then progress to the GUI
> tools (and, although it's not 100% clear from your post, I suppose that
you
> are managing your database via Enterprise Manager?)
>
> What I'd suggest is that you should open up a DOS box, and type "exp" to
> invoke the export utility. It will the prompt you to supply a username
and
> a password. Then it prompts you for what you want to export and how. It
> makes things like authentication errors very visible (painfully so!).
> That's export in interactive mode. After that, progress to specifying all
> the options as command line parameters (ie, exp system/manager full=y
rows=n
> indexes=y constraints=n file=d:\mydmp.dmp ...and so on).
>
> When you know how to use a tool manually, then the magic of the GUI is
> understandable. I've been told this is an old-fashioned approach, and
that
> if Oracle were any good, the GUI would be sufficient. But that's simply
not
> true -as a hardened Windows user and Unix-hater, I love a good GUI, but I
> much prefer to be in complete control of my database, and understand what
is
> going on.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "armin" <areick_at_incat.de> wrote in message
> news:a7799821.0203190819.205de055_at_posting.google.com...
> > hello,
> >
> > i'm rather new to oracle. anyway, i did a standard installation
> > on win 2000 and everything is running fine with the application.
> >
> > When trying to run an export from the database i get the information
> > that the job was submitted.
> > But the status of the job in the Active Jobs pane says 'failed'
> > (VNI-2015: Authentication error)
> >
> > thanx for any help
> > armin
>
>
Received on Tue Mar 19 2002 - 13:07:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US