OraFAQ Forum: Server Utilities » problems in IMPORT

Home » RDBMS Server » Server Utilities » problems in IMPORT

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

problems in IMPORT [message #139234]

Mon, 26 September 2005 23:12

sanaafridi
Messages: 50
Registered: August 2005
Location: pakistan

Member

hi

i am facing a problem in import.i have win2003 server and oracle 9.2.i have 2 databses on my machine.

i took EXP of one my databses (a user level export) and the EXP done noramally 1.e following appear

. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

now when i IMP through interacitve mode so it went successfully but when i check the user so only the VIEWS are imported no tables

why??

regrds

sana

Report message to a moderator

Re: problems in IMPORT [message #139237 is a reply to message #139234]

Mon, 26 September 2005 23:46

sanaafridi
Messages: 50
Registered: August 2005
Location: pakistan

Member

HI ALL

well i found something in its log file

IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 22 in tablespace NUST
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "ES_EM_PREF" ("PREF_ID" VARCHAR2(20), "EMP_ID" VARCHAR2(15), ""
"CHOICE" NUMBER, "PREF_INST" VARCHAR2(10), "POST_APPLIED" VARCHAR2(30), "USE"
"R_ID" NUMBER, "USER_DT" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 26542080 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "NUST""
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace NUST

there are a lot of error s as above
there are 419 bojects and after IMP there are total 224 objects in the new user .now

well its seems to me that autoextend is off but
i check the tablesapce and its autoextend is on

plzz help???

sana

Report message to a moderator

Re: problems in IMPORT [message #139268 is a reply to message #139237]

Tue, 27 September 2005 03:10

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

hi sana,

A good asktom thread
http://asktom.oracle.com/pls/ask/f?p=4950:9:3285383680953482052::NO:9:F4950_P9_DISPLAYID:11511550949535
to read

hope it would help you.

[Updated on: Tue, 27 September 2005 03:12]

Report message to a moderator

Previous Topic:	Loading Problem
Next Topic:	Importing data from .csv file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 06:39:38 CST 2024