OraFAQ Forum: Server Utilities » help me. ora-02219 when import on Oracle8.0.5

Home » RDBMS Server » Server Utilities » help me. ora-02219 when import on Oracle8.0.5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help me. ora-02219 when import on Oracle8.0.5 [message #71553]

Fri, 22 November 2002 00:43

iamseaver
Messages: 6
Registered: November 2002

Junior Member

imp80 zkgl/aaa file=d:zkphoto.dmp tables=zkphoto

Export file created by EXPORT:V08.00.05 via conventional path

.. importing ZKGL's objects into ZKGL

CREATE TABLE "ZKPHOTO"
(
"SID" CHAR(15) NOT NULL ENABLE,
"LPHOTO" BLOB,
"LP" LONG RAW
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
LOGGING STORAGE
(INITIAL 2147483646 NEXT 2150129664 MINEXTENTS 1 MAXEXTENTS 121
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "ZKGL"
LOB ("LPHOTO")
STORE AS
(
ENABLE STORAGE IN ROW TABLESPACE "ZKGL" CHUNK 2048 PCTVERSION 10 NOCACHE
LOGGING STORAGE (INITIAL 12288 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT)
INDEX (TABLESPACE "ZKGL" INITRANS 2 MAXTRANS 255 STORAGE (
INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1
FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
)

IMP-00003: ORACLE error 2219 encountered

ORA-02219: invalid NEXT storage option value

Report message to a moderator

Re: help me. ora-02219 when import on Oracle8.0.5 [message #71556 is a reply to message #71553]

Fri, 22 November 2002 05:43

B
Messages: 327
Registered: August 1999

Senior Member

create ur table (empty) with the correct INITIAL and NEXT before running imp
use option ignore=y ( imp )

INITIAL 2147483646 NEXT 2150129664

Value are too high ... or export the DB source with COMPRESS=N

Report message to a moderator