Oracle Database Discussions

Hi,


Getting an error while trying to create table under any of the schema's available:

Schema: larry
==========================================
SQL> create table "larry"."test"("orabora" varchar2(10));
create table "larry"."test"("orabora" varchar2(10))
*
ERROR at line 1:
ORA-01918: user 'larry' does not exist
==========================================


Schema: scott
==========================================
SQL> create table "scott"."testd"("testsize" varchar2(10));
create table "scott"."testd"("testsize" varchar2(10))
*
ERROR at line 1:
ORA-01918: user 'scott' does not exist
==========================================


So, the problem is with all of the user's (Schema's) in database.
Below is the search result validates availability and presence of discussed schemas.
++++++++++++++++++++++++++++++++++++++++++++++++
SQL> select * from ALL_USERS;

USERNAME USER_ID CREATED
------------------------------ ---------- ---------
PDIXIT_ADMIN 61 29-JAN-12
BI 60 27-JAN-12
PM 59 27-JAN-12
SH 58 27-JAN-12
IX 57 27-JAN-12
OE 56 27-JAN-12
HR 55 27-JAN-12
SCOTT 54 30-JUN-05
MGMT_VIEW 53 30-JUN-05
LARRY 62 29-JAN-12
MDDATA 50 30-JUN-05
+++++++++++++++++++++++++++++++++++++++++++++++++

Please assist.


Thanks
- Prashant Dixit