Ask the Expert

Creating a database on raw partition

I tried to create a database on raw partition with the command:
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 DATABASE
When 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?

    Requires Free Membership to View

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/c0t0d0s6 
Similarly 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


This was first published in December 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: