Re: ORA-28009

From: <>
Date: Tue, 16 Feb 2010 02:30:26 -0800 (PST)
Message-ID: <>

On 15 Feb, 23:19, syd_p <> wrote:
> On 15 Feb, 23:07, Mladen Gogala <> wrote:
> > On Mon, 15 Feb 2010 11:33:40 -0800, joel garry wrote:
> > > Have you set things up so someone can connect remotely as sys there?
> > > Connecting locally merely means the local user has group rights.
> > The OP has asked the same question on the DBI group and Jared Still, of
> > the "Perl for an Oracle DBA" fame, has given him the same answer I did..
> > --
> 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

You could try this:

SQL> create user dbauser identified by xxxxxx;

User created.

SQL> grant dba to dbauser;

Grant succeeded.

SQL> conn dbauser/xxxxxx
SQL> SQL> create tablespace test1 datafile 'test1.dbf' size 10M;

Tablespace created.

SQL> create user test1 identified by test1;

User created.

SQL> drop tablespace test1 including contents and datafiles;

Tablespace dropped.

SQL> drop user test1;

User dropped.

SQL> sho user
USER is "DBAUSER" Received on Tue Feb 16 2010 - 04:30:26 CST

Original text of this message