Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to enable Online Redefinition option

Status
Not open for further replies.
theresatan

theresatan

Programmer
Mar 18, 2002
101
US
Hi,

I wanted to reorganize table and ran following:

execute dbms_redefinition.can_redef_table ('SCOTT','EMP');

I got following error
*
ERROR at line 1:
ORA-00439: feature not enabled: Online Redefinition
ORA-06512: at "SYS.DBMS_REDEFINITION", line 8
ORA-06512: at "SYS.DBMS_REDEFINITION", line 247
ORA-06512: at line 1

From v$option I can see the valuet is 'False'.

How can I enable it?

Thanks!

Theresa
 
Status
Not open for further replies.

Similar threads

J
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
55
jj10438
J
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
1K
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
716
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
778
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
723
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top