dbTalk Databases Forums  

alter index (Oracle Text index) rebuild on different schema => norights

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss alter index (Oracle Text index) rebuild on different schema => norights in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema => norights - 01-23-2008 , 01:14 PM






On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Quote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan

I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #32  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema => norights - 01-23-2008 , 01:14 PM






On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Quote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan

I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #33  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema => norights - 01-23-2008 , 01:14 PM



On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Quote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan

I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


Reply With Quote
  #34  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema =>no rights - 01-24-2008 , 02:08 PM



Vladimir M. Zakharychev wrote:
Quote:
On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan


I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Which I indicated about a week ago, but reading
seems hard these days...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #35  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema =>no rights - 01-24-2008 , 02:08 PM



Vladimir M. Zakharychev wrote:
Quote:
On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan


I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Which I indicated about a week ago, but reading
seems hard these days...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #36  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema =>no rights - 01-24-2008 , 02:08 PM



Vladimir M. Zakharychev wrote:
Quote:
On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan


I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Which I indicated about a week ago, but reading
seems hard these days...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #37  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: alter index (Oracle Text index) rebuild on different schema =>no rights - 01-24-2008 , 02:08 PM



Vladimir M. Zakharychev wrote:
Quote:
On Jan 23, 4:01 pm, Krabatz <krab... (AT) gmail (DOT) com> wrote:
Thanks, that helps. Just for readers of this thread with similar
problems. The correct syntax is:
... PARAMETERS ('SYNC(ON COMMIT)');

Cheers,
Jan


I stand corrected - sync mode should indeed be enclosed with
parentheses.

Cheers,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Which I indicated about a week ago, but reading
seems hard these days...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.