• 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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!