Add new datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Add new datafile

  1. #1
    Join Date
    Sep 2007
    Posts
    47

    Add new datafile

    hi, I want to add a datafile to existing tablespace. But the directory /u01, where oracle_home and datafiles are present has no space. The operating system is Solaris.

    Question: Can I add a datafile to existing tablespace in another directory
    /u02 ? If yes, do I need to change the owner and group of the new datafile in /u02. Do I need to change the ownership to same as datafiles of /u01?


    thanks,
    Last edited by rehan khan; 11-21-2007 at 02:51 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    course you can, do you not have a dba around who can help you?

  3. #3
    Join Date
    Sep 2007
    Posts
    47

    Add new datafile

    hi, there is no DBA here. Can you please help me in solving this.


    thanks,

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by rehan khan
    hi, there is no DBA here. Can you please help me in solving this.
    You are asking a lot of questions in the forum -it is not a "solving this" issue, you have a lot of problems there, probably much more than you can see. You need a DBA.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width