Re: ORA-28009
Date: Tue, 16 Feb 2010 13:57:31 +0000 (UTC)
Message-ID: <hle88b$o1q$4_at_solani.org>
On Mon, 15 Feb 2010 15:19:11 -0800, syd_p wrote:
> Hi Guys,
> I am the OP and actually I have only asked the question on this group. I
> kind of thought the answer lies in the Oracle world, hence my posting in
> this group.
> I guess I did not phrase the question very well. The problem is that I
> have a selection of scripts that dont like "sys as sysdba" as a
> username.
> Dont know why and I dont want to mess with the scripts. What I need is
> a username of one word (not three that makes the scripts barf)
> that has the powers to create tablespaces and users in a database that I
> created with dbca.
>
> Maybe that is possible? If so please help me. Thanks for your input so
> far!
>
> Syd
Syd, what are you actually trying to do? Logging in as SYS is normally
done to shut down or start up the database. There are very few things
that require the SYSDBA privilege. The only exception to the rule is
using the X$ tables but not even that should be done carelessly. Reading
some of the X$ tables can greatly increase latch activity and severely
impact the system.
Starting and stopping database from a Perl script is a very unusual
choice and should be reconsidered very carefully.
-- http://mgogala.freehostia.comReceived on Tue Feb 16 2010 - 07:57:31 CST