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 11:20:15 GMT
Message-ID: <PJhHa.2901$%3.182922@typhoon.sonic.net>

"Chris Vowles" <chris_vowlesREMOVE_at_REMOVEhotmail.REMOVE.com> wrote in message news:h65rev8cbc6740isghjqcucqfobeng5bgc_at_4ax.com...
> On Mon, 16 Jun 2003 03:08:09 GMT, "Paul W" <pwatkins_at_ivrusa.com>
> wrote:
>
> >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 ?
> >
>
> imp help=y
>
> will give all the options such as grants=n
>
> e.g.
>
> C:\>imp help=y
>
>
> Keyword Description (Default) Keyword Description
> (Default)
> -------------------------------------------------------------------------
> USERID username/password FULL import entire file
> (N)
> BUFFER size of data buffer FROMUSER list of owner
> usernames
> FILE input files (EXPDAT.DMP) TOUSER list of usernames
> SHOW just list file contents (N) TABLES list of table names
> IGNORE ignore create errors (N) RECORDLENGTH length of IO record
> GRANTS import grants (Y) INCTYPE incremental import
> type
> INDEXES import indexes (Y) COMMIT commit array insert
> (N)
> ROWS import data rows (Y) PARFILE parameter filename
> LOG log file of screen output CONSTRAINTS import constraints
> (Y)
>
> etc
>
> Chris

Still looking for the answer to my question, is there a wildcard that I can use for the tables= command?

Paul Received on Mon Jun 16 2003 - 06:20:15 CDT

Original text of this message

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