importing records [message #277721] |
Wed, 31 October 2007 05:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Hi Michel,
I am importing millions of records.
I have created the necessary tablespace with autoextend on option.
During import i am getting folowing error:
ora-00017
thanks
|
|
|
|
|
|
|
Re: importing records [message #277738 is a reply to message #277721] |
Wed, 31 October 2007 05:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
In the alert log i found ora-1652: unable to extend temp segment by 388548 in tablespace rpli.
Duirng the import when large table comes it shows the error.
|
|
|
|
Re: importing records [message #277746 is a reply to message #277721] |
Wed, 31 October 2007 06:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
I enlarged my tablespace. When i ran import there were some tables that failed to get created .Now iam trying to import them individually but getting the error:
IMP-00017: following statement failed with ORACLE error 1658:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RPLI
|
|
|
|
Re: importing records [message #277751 is a reply to message #277721] |
Wed, 31 October 2007 06:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Quota is unlimited but still the problem.
The create table statements in import have minextents ,maxextents pctincrease options.
I created the tablespace with autoextend on option.
Do i need to create the tabelspace with options as in the create table statements seen during import?
|
|
|
|
|
|
|
Re: importing records [message #277771 is a reply to message #277746] |
Wed, 31 October 2007 08:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
varu123 wrote on Wed, 31 October 2007 07:21 | I enlarged my tablespace. When i ran import there were some tables that failed to get created .Now iam trying to import them individually but getting the error:
IMP-00017: following statement failed with ORACLE error 1658:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RPLI
|
Then add more space to the tablespace (or do what Michel has suggested). You do not have enough contiguous space to create the INITIAL extent, which may be the size of the entire table if you used COMPRESS=Y, which is the default in 10gR2.
|
|
|
Re: importing records [message #278046 is a reply to message #277721] |
Thu, 01 November 2007 11:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
I increased the tablespace size,rollback segment size and issue alter tablespace coalesce statement .But there are some tables that give the same error every time i try to import them.
|
|
|
Re: importing records [message #278048 is a reply to message #278046] |
Thu, 01 November 2007 11:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
We can't help you more.
All informations are in the topic.
Just follow them.
Once again check the value for initial extent we can't see over your shoulders.
Regards
Michel
[Updated on: Thu, 01 November 2007 11:32] Report message to a moderator
|
|
|
Re: importing records [message #278050 is a reply to message #277721] |
Thu, 01 November 2007 11:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Ok, i checked the create table statements during import. They have initial ,next ,minextent values different from values in the tablespace i created for that user.
Is this difference causing the problem?
Do i have to drop and recreate the tablespace with storage clauses as mentioned in the create table statement?
If yes than why import for other tables is working?
|
|
|
|
Re: importing records [message #278058 is a reply to message #277721] |
Thu, 01 November 2007 12:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
There are five tables that are giving this error.Rest of the tables got imported well.
I think i have to manually create these tables and then insert data.
|
|
|
|
|
Re: importing records [message #278064 is a reply to message #277721] |
Thu, 01 November 2007 12:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
I dont think but they are.
I created one table. Initially it gave the same error. Then i issued alter tablespace coalesce statement, it worked.
I issued this statement during import also but no success.
|
|
|
Re: importing records [message #278069 is a reply to message #278050] |
Thu, 01 November 2007 12:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
varu123 wrote on Thu, 01 November 2007 12:48 | Ok, i checked the create table statements during import. They have initial ,next ,minextent values different from values in the tablespace i created for that user.
|
Of course, because those values for the objects. It has nothing to do with what values the tablespace has.
Either pre-create your objects in a locally managed tablespace or don't be stingy with adding space to the tablespace.
You still haven't told us what the INITIAL and NEXT values are for the create table statement. What's the secret? Why don't you provide all the helpful information up front so the thread doen't have to go to 20+ messages/
|
|
|
Re: importing records [message #278072 is a reply to message #277721] |
Thu, 01 November 2007 13:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
The initial extent size is 750m,next is 450m as appear in import.The original create table statements do not have any storage clauses.
|
|
|
Re: importing records [message #278241 is a reply to message #278072] |
Fri, 02 November 2007 08:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
varu123 wrote on Thu, 01 November 2007 14:16 | The initial extent size is 750m,next is 450m as appear in import.The original create table statements do not have any storage clauses.
|
Then your tablespace needs to have a contiguous chunk of 750M in order to create the object, even if no rows are to be inserted.
|
|
|
|