SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
ORA-01418 while moving SYS.AUD$ Table from SYSTEM tablespace

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
ORA-01418 while moving SYS.AUD$ Table from SYSTEM tablespace
Author Message
dfrancis



Joined: 16 Aug 2012
Posts: 5
Country: United States

Post ORA-01418 while moving SYS.AUD$ Table from SYSTEM tablespace Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
Ora-01418 means "specified index does not exist"

Which table and index are we talking about?
Tue Feb 26, 2013 11:54 am View user's profile Send private message
dfrancis



Joined: 16 Aug 2012
Posts: 5
Country: United States

Post Ora-01418 means "specified index does not exist" Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.