-
error during import
Hi,
I've a export file (XX.dmp).
I tried to import this dump for new records of tables there are in my db, but I get this errors:
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing AFM's objects into AFM
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SITE" ("ACRES" FLOAT(126), "AREA_EM_DP" FLOAT(126) "NOP" VARCHAR2(4)) PC"
"TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4980736 FREELIS"
"TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00008: unrecognized statement in the export file:
ýÿo
IMP-00008: unrecognized statement in the export file:
R
IMP-00008: unrecognized statement in the export file:
I think that export file is was corrupted.
How Can I import correctly??
Thanks
Raf
-
export again and import again....
Amar
"There is a difference between knowing the path and walking the path."
-
Does the table exist ? Have you tried with ignore=y ? And are you using Automatic Segment Space Management by any chance ?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
imp system/manager@mydb file=xx.dmp tables=A ignore=y fromuser=tom touser=tom log=xx.log
My db server is 9.0.1, while export made on oracle server 9.2.0.1
On server 9.2.0.1 not is setting the NLS_LANG
Could be this the problem???
Thanks
Raf
-
Originally posted by raf
My db server is 9.0.1, while export made on oracle server 9.2.0.1
In general, you can't "downgrade" directly using the export file. Search this forum on how to import a different version of an export file.
Jeff Hunter
-
Re: error during import
Originally posted by raf
"TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
COMPRESS/NOCOMPRESS for tables is valid option in 9.2, but not in 9.0, that's why it's complaining about invalid option.
You have to perform export with 9.0 exp utility to be able to import it into 9.2.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|