RE: svrmgrl vs sys account

I am not sure I understand your question, but basically, if you define the tablespace for your new user and the temporary tablespace too, then there is no difference.

It is important to avoid using the system tablespace for users data and temporary tables. That could lead to fregmentation and would be a risk to your database.

As far as rights and privileges go -- why don't you create a user for yourself with dba privileges and then avoid the use of the sys and system users altogether. Using sys is needed for only a small handful of actions, so try to stay away from causing use of the system tablespace by any actions as a user.

That's it for now,

   Mark

Mark Kirk
  Working toward the Oracle DBA OCP
    & seeking an entry level position...      mkirk_at_hot.ee <mailto:mkirk_at_hot.ee>

-----Original Message-----
sinardyxing_at_bcsis.com
Sent: Saturday, March 03, 2001 3:50 AM
To: Multiple recipients of list ORACLE-L

Hi,
I am a beginner DBA could you tell me
what is the diffrent:
create user /tablespace or else using
svrmgrl>
and sys account
oh ya.. I'm using Oracle8i

Thank you very much

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Kirk
  INET: mkirk_at_hot.ee

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).