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

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Mon, 16 Jun 2003 18:05:20 +0200
Message-ID: <3eedeabc$0$49115$e4fe514c@news.xs4all.nl>

Paul W <pwatkins_at_ivrusa.com> schreef in berichtnieuws PJhHa.2901$%3.182922_at_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
|

No wildcard as said. Check imp help=y and exp help=y for all options and open the Utilities Guide for an explanation. Two options: a. make a user export (instead of a table export) (with owner=...) b. from the source db generate a list of tables with a statement like "select ','||table_name from user_tables;" and little edit work remains for the parameter file. Note however that there is a limit on the size of the parameter file. I think 4Kb if I recall it well. So if there are many tables maybe you must split it in 2 runs.
With exp parameters as grants=n indexes=n triggers=n constraints=n you can limit it to table data only but I doubt that's what you want if you want a development environment for the application. Think you have more than enough hints and directions to docs to solve it now. Received on Mon Jun 16 2003 - 11:05:20 CDT