![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
dfrancis
Joined: 16 Aug 2012 Posts: 5 Country: United States |
|
ORA-01418 while moving SYS.AUD$ Table from SYSTEM tablespace |
|
I created two table spaces. One for the data and the other for the index. During the move process I selected the two table spaces then press the Continue button. Here it complained about the Index and gave me the ORA-01418 error.
|
|
Tue Feb 26, 2013 11:45 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
Ora-01418 means "specified index does not exist"
Which table and index are we talking about?
|
|
Tue Feb 26, 2013 11:54 am |
|
![](templates/GreenTech/images/spacer.gif) |
dfrancis
Joined: 16 Aug 2012 Posts: 5 Country: United States |
|
Ora-01418 means "specified index does not exist" |
|
I am moving the SYS.AUD$ table from the SYSTEM table space. In this process you are given a dropdown list box to choose two tablespaces. One tablespace is for the new location for SYS.AUD$ table and the othjer is for the new location for indexes from SYS.AUD$ table. I PRE-CREATED TWO table spaces and choose these two tablesapces as the new locations. It is complaining about the new tablespace by giving me the ORA-01418 error.
|
|
Tue Feb 26, 2013 12:38 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|