How to disable OMF in 10g?
RDBMS Version: 102010
Operating System and Version : Windows 2003
Error Number (if applicable) : NA123
Product (i.e. SQL*Loader, Import, etc.) : Oracle 102010 EE
Product Version : 102010 EE
Hello,
I have 102010 database where it was created with OMF (db_create_file_dest has a value).
I'd like to disable OMF, how to do this?
I tried
alter system reset db_create_file_dest scope=spfile;
and
alter system reset db_create_file_dest scope=both;
Bt both statements failed with:ORA-00905: Missing keyword
Many thanks in advance for your help.
Thamer
Operating System and Version : Windows 2003
Error Number (if applicable) : NA123
Product (i.e. SQL*Loader, Import, etc.) : Oracle 102010 EE
Product Version : 102010 EE
Hello,
I have 102010 database where it was created with OMF (db_create_file_dest has a value).
I'd like to disable OMF, how to do this?
I tried
alter system reset db_create_file_dest scope=spfile;
and
alter system reset db_create_file_dest scope=both;
Bt both statements failed with:ORA-00905: Missing keyword
Many thanks in advance for your help.
Thamer
0