| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing Database - I'm at my wit's end...
"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
![]() |
![]() |