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.
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: 10672
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
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.
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
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:
  


Current Time: Tue Dec 06 04:17:23 CST 2016

Total time taken to generate the page: 0.22674 seconds