Home » RDBMS Server » Server Administration » sys user problem (oracle 9i windows)
sys user problem [message #377717] Wed, 24 December 2008 09:48 Go to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
hi

i connected as sys user and i want to create datafile or create user, but the oracle through error saying insufficient privilege,but i connected as sys user what the reasion behind this,pls help me.

Report message to a moderator

Re: sys user problem [message #377748 is a reply to message #377717] Wed, 24 December 2008 16:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Instead of explaining what you did, post what you did.
Copy and post the session within CODE tags

Report message to a moderator

Re: sys user problem [message #378003 is a reply to message #377717] Sat, 27 December 2008 12:36 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
put complete screen shot.


diospl;aying show user & create tablespace or alter tablespace system add datafile comaand & error.

Report message to a moderator

Re: sys user problem [message #380704 is a reply to message #377717] Tue, 13 January 2009 01:19 Go to previous message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
is it windows? if so check whether your OS user is added to ORA_DBA group or not

Report message to a moderator

Previous Topic: how to refresh v$session with out kill session
Next Topic: How to move the datafiles from one place to another?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 24 06:24:00 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.