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: Importing Database - I'm at my wit's end...

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

From: Paul W <pwatkins_at_ivrusa.com>
Date: Mon, 16 Jun 2003 03:08:09 GMT
Message-ID: <twaHa.2748$%3.176578@typhoon.sonic.net>

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:3eec4641$0$49114$e4fe514c_at_news.xs4all.nl...
>
> Paul W <pwatkins_at_ivrusa.com> schreef in berichtnieuws
> 4kWGa.2633$%3.170776_at_typhoon.sonic.net...
> | 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
> |
>
> Most likely grants are given to a user or role that does not exist.
> Specify ignore=Y (default is N) as parameter, then import will continue
> after errors.
> Other actions depends on what import you are doing (full? fromuser/touser?
> user import?) and what you want to achive. It could be better to create
the
> role(s) or user(s) prior to import, otherwise privilige problems could
make
> the application not to run properly in this development database.
>

Thankfully, I'm not trying to run any applications, just get the data, so that I can refer to it with an external application. Is there a way to specify a wildcard in the import command so that I can get only the tables and data to import ? Received on Sun Jun 15 2003 - 22:08:09 CDT

Original text of this message

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