Home » SQL & PL/SQL » SQL & PL/SQL » Rebuild an index -ONLINE-
Rebuild an index -ONLINE- [message #191046] Mon, 04 September 2006 04:51 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
Hello folks,

Using SQLPLUS, I submit the following statement: " alter index ndx_cust_name rebuild ONLINE; "

I then receive the following error message:

" Error ORA-08106 can not create table journal System.sys_journal_7237 "

What is the problem? What should I do to solve it?

.. Thankful for any help Smile
Re: Rebuild an index -ONLINE- [message #191076 is a reply to message #191046] Mon, 04 September 2006 06:45 Go to previous messageGo to next message
venkatbollu
Messages: 53
Registered: April 2005
Location: Bangalore
Member

But its working fine when I do it in my machine, so plz check your priveleges.
Re: Rebuild an index -ONLINE- [message #191078 is a reply to message #191046] Mon, 04 September 2006 07:11 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Which version are you running ?
I know there have been some bugs reported at metalink concering this issue.
Previous Topic: connect by prior?
Next Topic: dynamic Query
Goto Forum:
  


Current Time: Thu Dec 08 08:09:38 CST 2016

Total time taken to generate the page: 0.22807 seconds