Auto Extend

Dear EE,

can we set autoextend table space if user does not have SYSDBA rights, if yes then how?
Thanks!
Netsol-NOSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sventhanCommented:
if you have a DBA role/privs you can able to set this autoentend on. See if you have the DBA role.
0
johnsoneSenior Oracle DBACommented:
If you are trying to modify the SYSAUX tablespace, then SYSDBA privileges are required.  Otherwise, either the ALTER TABLESPACE or MANAGE TABLESPACE privilege should be all that  is required.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsoneSenior Oracle DBACommented:
Why the penalty grade?  What part of your question was not answered?  If you needed additional information why didn't you request it?

The grading rules are here -> http://support.experts-exchange.com/customer/portal/articles/481419
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Netsol-NOSAuthor Commented:
Dear Johnsone,

My Apology if my comments hurt you. I should ask you but i have forwarded your reply to my concern department and along with your answer they perform some other actions too on the DB and that also included in the resolution.

So that why i choose the grade.

Again i apology if my comments hurt your feelings.

Please confirm me if i can revert it back.

Thanks
0
johnsoneSenior Oracle DBACommented:
To change it, you should be able to hit "request attention" and have the question re-opened.

If other things were done to resolve the problem, the details of that should be posted here for others that may have a similar issue in the future.  However, based on your generic question, I believe it has been answered as best we could with the information provided.
0
Netsol-NOSAuthor Commented:
If you are trying to modify the SYSAUX tablespace, then SYSDBA privileges are required.  Otherwise, either the ALTER TABLESPACE or MANAGE TABLESPACE privilege should be all that  is required.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.