I tried to create a database on raw partition with the command:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
CREATE DATABASE RAW LOGFILE '\.L:' SIZE 10M, '\.M:' SIZE 10M, '\.N:' SIZE 10M MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE '\.S:' SIZE 20M MAXDATAFILES 254 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1;and I got the error:
ORA-02165: invalid option for CREATE DATABASEWhen I tried:
ALTER DATABASE ADD LOGFILE GROUP 4 ('\.J:')on database that wasn't created on raw partition, it works. Does it mean I can't create a database on raw partition, just create tablespace or logfile and to add them to an existing database?
You should be able to create the DB on raw partition just fine. Before creating the database you need to prepare the partitions on which datafiles will be created. The size of the partitions should be greater (at least two Oracle blocks) than the datafile size that you are going to create. You can create the partitions using "format" command as root user. Once partitions are created, change the owner and group of raw partition to oracle and dba. If your raw partition is /dev/rdsk/c0t0d0s6
chown oracle:dba /dev/rdsk/c0t0d0s6Similarly for all the raw partitions. Note that the raw partition should be character device (and not block device).
Now, create the database with REUSE option for each datafile and logfile which are going to be on the raw partition.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.