Re: imp: limit on number of tables?

Chuck wrote:

> Oracle 9.2.0.05 running on Solaris
>
> Is there a limit on the number of tables you can specify in an import
> parameter file? If so I haven't found it in the 9i documentation.
>
> I have a list of 598 tables that I need to reload from an import file
> (all the tables for one Peoplesoft tablespace). I can't use wild cards
> as they would probably match other tables in the export file. I
> constructed a parameter file by spooling the table names and editing it.
> When I run the import it just hangs. The import session is waiting
> indefinitely on "sqlnet message from client" so it's doing nothing. The
> parameter file is below. The only output I ever see is
>
> "Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.5.0 - Production
>
> Export file created by EXPORT:V09.02.00 via direct path
> import done in US7ASCII character set and AL16UTF16 NCHAR character set
> import server uses WE8ISO8859P15 character set (possible charset
> conversion)
> export client uses WE8ISO8859P15 character set (possible charset
> conversion)"
>
> Here's what the import.par file looks like...
>
> userid=/
> file=/oramisc/backup/NSFSDEV/full_exportNSFSDEV121904_05:30.dmp
> fromuser=sysadm
> touser=sysadm
> buffer=1048576
> commit=y
> tables=(
> PS_ACCT_TYPCD_LNG,
> PS_ACTION_LST,
> [596 table names snipped]
> )

Some random suggestions:

If you set the feedback parameter i.e. Feedback=1000, imp will print a period every 1000 rows. Might provide some perspective on whether it's hanging, or just taking a long time.

I've also found setting the log parameter helps decipher what's going on by providing a permanent log.

Try a dry run by setting show=y, rows=n

Try it with one table and see if you can get it to work. If you are running into some kind of limit on number of tables you can probably break it up into half a dozen chunks.

Good luck.

-- 
//-Walt
//
//