| problem In Import [message #331970] |
Mon, 07 July 2008 01:02  |
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
|
Senior Member |
|
|
Hi
I have a DUMP file that create with export in Version 9.2.0.1.0.
and I want to Import this file in version 9.0.1.0.0 .
when i use IMP , the following error ocoured :
" following statment faild with ORACLE error 922
CREATE TABLE " statments of create my table "
PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255 Storage (INITIAL 73728 FREELISTS
FREELIST GROUPS 1 ) TABLESPACE "USERS "
IMP-00003 : ORACLE error 922 encountered
ORA-00922 : missing or invalid option .
ThanQ
|
|
|
|
| Re: problem In Import [message #331973 is a reply to message #331970] |
Mon, 07 July 2008 01:09  |
 |
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
You have to use 9.0 export program on your 9.2 database in order to import into a 9.0 database.
Note that export/import is NOT a backup/recovery tool.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
