Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Index Error (Oracle)

 
Younes Essouabni
Ranch Hand
Posts: 479
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I've done a small application to migrate data from an Oracle Database to another Oracle Database. The problem is that after 700.000 rows read and inserted, I get a ORA-01654 error.
java.sql.SQLException: ORA-01654: unable to extend index MYSCHEMA.PK_MKIMNOTIFICATION by 2397 in tablespace MYSCHEMA
I understand from Google groups that I have to add a Datafile to to my tablespace. My question is may I add the Datafile with Java, without corrupting the Data. I mean may I do something like this:

Is it a problem to do this?
Thx for your answers!
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have no idea if it that would work or not. The point is that adding datafiles should be done by a DBA not a developer, and definately not an application.
SImon
 
Younes Essouabni
Ranch Hand
Posts: 479
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Simon,
I realized that the application doesn't have enough rights to do it
Anyway thank you for your answer
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic