Re: ORA-28009

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sun, 14 Feb 2010 15:30:53 -0800 (PST)
Message-ID: <c9892973-97c3-4947-8cf3-14ab3e10591a_at_k6g2000prg.googlegroups.com>

Create another user and create tables so they are owned by this user.

create user ABC identified by ABC
default tablespace USERS
temporary tablespace TEMP;

grant CONNECT,RESOURCE to ABC;

After that connect as ABC/ABC and create tables, indexes, etc. Received on Sun Feb 14 2010 - 17:30:53 CST