Ok the question is obviously wrong as it stands, but I'm wondering how can I choose storage implementations on Oracle as I would for MySQL, say I want one table to MyIsam like and another for Archiving only and one Black Hole style for test purposes. How would I go around to doing this within a single Schema, or something similar that would meet these needs?
A:
You may use ORGANIZATION EXTERNAL:
CREATE TABLE ORGANIZATION EXTERNAL
and select an access driver to use with it.
As for now, Oracle has ORACLE_LOADER to access CSV and like text tables (read-only), and ORACLE_DATAPUMP to read and write binary data (in custom format).
Quassnoi
2009-02-13 13:41:40
Have a link to a tutorial on that?
Robert Gould
2009-02-13 13:46:53
Sorry, it seems you cannot develop one youself, yet :)
Quassnoi
2009-02-13 13:48:55
Thanks for the try anyways. That might come in handy for another thing I need to do.
Robert Gould
2009-02-13 13:52:05
External tables are not a storage engine concept. They are used to read text files from Oracle and their purpose is to load data from text files into the database. You cannot perform DML operations on those.
Yas
2009-02-13 14:42:35
+1
A:
Oracle does not have a storage engine concept like Mysql does. It stores all tables in its own format in datafiles. What you can do is use different tablespaces and store them on different disks whose performance characteristics may be different.
The concepts guide may help you understand how Oracle works.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
Yas
2009-02-13 14:40:18