-
Strange Import problem
I too a full export of a db on Win2K to create another db on the same platform. After creating the db and creating the users, I attempted to import the data with full=y, but it skips all the tables!! Any clues?? Thanx.
-
Re: Strange Import problem
Originally posted by Halo
I too a full export of a db on Win2K to create another db on the same platform. After creating the db and creating the users, I attempted to import the data with full=y, but it skips all the tables!! Any clues?? Thanx.
Did you create the tablespaces? If the tablespaces don't exist then the import will attempt to create them. If they already exist then it won't create the tablespace and thus the schema owner who has a default tablespace missing.
Are you getting any errors during the import?
-
Yes, the tablespaces have been created. I then created the users and assigned the privs. Import does not throw any errors. During import, all I see it doing is skipping all tables. It's a full export that I am importing with full=y, ignore=y.
-
The import does not have any errors? Did you spool a logfile?
Are you sure the table structures are not there?
Did you save the export logfile? Can you verify that there is data in it?
MH
I remember when this place was cool.
-
No errors in the logfile, except for IMP 00046. I have 12 files (2Gb) each to be imported. Export logfile does show data being exported. The tables are not in the db. Imp logfile says:
..skipping table throughout the logfile to the very end.
-
IMP-00046 using FILESIZE value from export file of string
Cause: Either you did not specify the FILESIZE parameter in your IMPORT command, or you specified FILESIZE=0 and the export file was created with a non-zero value for FILESIZE. Import will use the value specified in the export file.
Action: No action required.
Did you set filesize to zero.
I remember when this place was cool.
-
You may want to check the filesize parameter.
Even though Tahiti says that no action is required for the error.
Code:
IMP-00046 using FILESIZE value from export file of string
Cause: Either you did not specify the FILESIZE parameter in your
IMPORT command, or you specified FILESIZE=0 and the export file was
created with a non-zero value for FILESIZE. Import will use the value
specified in the export file.
Action: No action required.
-
Originally posted by Halo
Imp logfile says:
..skipping table
This happens when you perform import with ROWS=N.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Ok, maybe he should post the .PAR file?
I remember when this place was cool.
-
FILESIZE is an environmental variable, did you SET it?
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|