how to add datafile to tablespace on ASM

 

Add datafile to tablespace  ASM diskgroup  DATAGROUP

SQL> alter tablespace USER-TABLESPACE add datafile '+DATAGROUP' size 10G;
Tablespace altered.
SQL>

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Database administration. Bookmark the permalink.

5 Responses to how to add datafile to tablespace on ASM

  1. Jonathan says:

    the datafile needs to be created

  2. sidewinder says:

    The post is not correct.
    add datafile ‘+DATAGROUP/directory/filename’

    • Sher khan says:

      Hi,

      Sorry for my delay response, the datafile will create for the tablespace in ASM group.

      My sql statment is
      alter tablespace USER-TABLESPACE add datafile ‘+DATAGROUP’ size 10G;

      Tablespace name is USER-TABLESPACE: is the tablespace you want to add datafile.

      ASM group for me is DATAGROUP, It could be different for your environment.

      Regards,
      Sher

  3. sidewinder says:

    Please disregard my previous comment.
    We just need to specify datagroup of the tablespace we add the file.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s