Re: Importing Database - I'm at my wit's end...

"Paul W" <pwatkins_at_ivrusa.com> wrote in message news:dHVGa.2631$%3.170676_at_typhoon.sonic.net...
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:ch1oevg4ehre3u5o6buh9u3aj813e433lm_at_4ax.com...
> > On Sun, 15 Jun 2003 02:52:19 GMT, "Paul W" <pwatkins_at_ivrusa.com>
> > wrote:
> >
> > >I'm running Oracle 9i release 2, finally went through a few days of
> > >headaches getting the system setup and running properly. I have a
> database
> > >established and working, now I'm trying to import tables and data from
an
> > >export file, and I'm running into an issue with the node credentials
not
> > >having proper authentication and/or not having the "logon as batch
file"
> > >ability.
> > >
> > >For some reason, the Oracle configuration wizards can't seem to plug
into
> > >the Active Directory service that I already have running for
> authentication,
> > >it runs into an exception, and doesn't specify what that exception is.
> In
> > >the meantime, I've tried plugging in the external OS user accounts that
I
> > >was able to specify as the node credentials, all to no avail.
> > >
> > >I believe the issue that I'm having is that the Enterprise Manager is
not
> > >using the external OS credentials properly, or I missed something in
the
> > >setup, but I can't get this file to import. I'm not quite clear on how
> the
> > >system is trying to use authentication for importing a local file,
(seems
> > >rather stupid to me...) If anyone has any suggestions on how I can get
> this
> > >file to import, I would be very appreciative.
> > >
> > >Paul
> > >
> >
> >
> > Just run imp. just run imp. It'll work!! (as opposed to fancy tools
> > for the physically handicapped)
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> Wow, it actually seems to be working! You are a god among men! If you
ever
> need help with telephony or networking, just drop me a line!
>
> Paul
>

Perhaps I spoke too soon, it ran across error #1435 saying that the user does not exist when it's going to import the tables, so it terminates. I'm just trying to recreate a production database, for development, and don't necessarily need the user information, is there a way around this in the command line?

Paul Received on Sun Jun 15 2003 - 03:42:40 CDT