Home » RDBMS Server » Server Utilities » problem In Import (9)
problem In Import [message #331970] Mon, 07 July 2008 01:02 Go to next message
alijeyan
Messages: 180
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 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: stats_pack results
Next Topic: problem in import
Goto Forum:
  


Current Time: Sun Dec 04 08:45:27 CST 2016

Total time taken to generate the page: 0.19883 seconds