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.
Printable View
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.Quote:
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.
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
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 tablethroughout 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.
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.
This happens when you perform import with ROWS=N.Quote:
Originally posted by Halo
Imp logfile says:
..skipping table
Ok, maybe he should post the .PAR file?
FILESIZE is an environmental variable, did you SET it?