Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Error 1

Status
Not open for further replies.

ado007

Technical User
Jun 24, 2002
40
GB
Dear All

I have just set up a new database and I'm trying to do a import. But after it has imported the first 4 tables, is start looging this message:-

IMP-00017: following statement failed with ORACLE error 1658:
"CREATE INDEX "ACTIONSI3" ON "ACTIONS" ("CONTACT_NO" ) PCTFREE 10 INITRANS "
"2 MAXTRANS 255 STORAGE(INITIAL 393216 NEXT 139264 MINEXTENTS 1 MAXEXTENTS 2"
"147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace LT27

And then is does this for every one after that.

Please help!!!!

Adrian
 
The LT27 tablespace appears to be full. You can correct this by expanding the existing datafile(s) or adding a new datafile to the tablespace.
 
Thanks for that it maked at treat. I had left the database at the default size.

Thanks

Adrian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top