Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to change default tablespace of self

Re: How to change default tablespace of self

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 18 Oct 2005 09:08:57 -0700
Message-ID: <1129651736.954006@yasure>


impraveen_at_gmail.com wrote:
> Hi
> Thanks for the response guys... There is only one owner and we do not
> want to give it DBA rights. Also, the separate tablespaces are for
> performance gain, i.e. one set of tables in one tablespace and other
> more performance hungry tables in other tablespace. One of the
> tablespace would be default for our owner.
> Also, Scripts are always run as owner.
> -Praveen

Read a good book on tuning. What you describe above makes no sense.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Oct 18 2005 - 11:08:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US