-
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 03:51 AM.
-
course you can, do you not have a dba around who can help you?
-
Add new datafile
hi, there is no DBA here. Can you please help me in solving this.
thanks,
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|