Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating omf-named tablespace and datafile in a non-omf database

3044648Mar 15 2016 — edited Feb 13 2017

Hi,

This is with regards to migration from 10g to 11g using export/import method.

I have an oracle database 10g in machine A(running in win 2003) and oracle database 11g in machine B(win 2008). The database in machine A uses OMF and the database in machine B uses non-OMF. My question is, Is it possible to create a OMF-named datafile to a non-omf database? because when i tried, it gave me "ora-01276 error, cannot add file, file has an oracle managed file" .

Now, is it possible to convert non-omf database to omf database?

What will i do with this? any suggestion will help.

Thank you.

This post has been answered by top.gun on Mar 15 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2016

Added on Mar 15 2016

#database-key-features, #export-import-sql-loader-external-tables

2 comments

1,107 views