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

As ususal, one question leads to another, and another.

In parallel with asking here, I recommend supplementing with the manual. All of the (literally 100s of) variations to the import/export commands are well documented in the Utilities guide. The documentaiton for all current versions can be accessed from Oracle's Technet and relatively directly from http://docs.oracle.com.

You mention Oracle9i Release 2 so all your manuals are at http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/index.htm and the utilities manual is at
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/docindex.htm#index-ULT

Note that the commands can use parameter files which can iunclude the table names as a list. You can also do a import without data and even "show" that to display or file. Thus you could do a no-data import to a file and use the results to create your parameter file.

HTH
/Hans

Paul W wrote:

> "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:26:19 CDT