|Subject:||imp: limit on number of tables?|
|Posted by:||Chuck (email@example.com)|
|Date:||Mon, 20 Dec 2004|
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 220.127.116.11.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 18.104.22.168.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
Here's what the import.par file looks like...
[596 table names snipped]
To reply by email remove "_nospam"