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: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 20 Mar 2002 06:13:45 +1100
Message-ID: <a782mh$45h$1@lust.ihug.co.nz>


What -about being a hardened Windows user, a Unix-hater or loving a good GUI??! ;-) (To my eternal shame, all 3 are true. However, if anyone would care to donate a nice Sparc machine, I *do* know how to use Solaris, and I could cope, I suppose).

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"koert54" <koert54_at_nospam.com> wrote in message
news:W%Ll8.18665$DE4.2380_at_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:13:45 CST

Original text of this message

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