| Oralci8/NT/"create schema" failure [message #373454] |
Tue, 17 April 2001 19:53  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Oracle8i/NT
For one of the users, I want to create an
identically named schema in which to create
some tables. I get: " ora-02421 -
missing or invalid schema authorization ID"
Script and error message follows:
---------------------
CREATE SCHEMA AUTHORIZATION PERSONNAME
CREATE TABLE ttable
(color VARCHAR2(10) PRIMARY KEY, quantity NUMBER);
---------------------------
SQL> 2 3 CREATE SCHEMA AUTHORIZATION PERSONNAME
ERROR at line 1:
ORA-02421: missing or invalid schema authorization identifier
--------------------------------------
1) Question is, how do I create a new schema
for a user name in oracle 8i? If I know the
user is in fact there, why would it say
missing schema identifier ?
2) How would I copy an existing schema &
make it into another schema ( but under a
different name) ?
3) short example sql to do this would be nice.
|
|
|
|
| Re: Oralci8/NT/"create schema" failure [message #373459 is a reply to message #373454] |
Wed, 18 April 2001 08:15  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
When you create a user, you are creating schema also. You don't need to explicitly create any schema.
To copy the objects from one schema to other.
for ex. A to B
First as dba or as A grant select on all the objects owned by A to B.
like
Grant select on table1 to B;
and log on as B
either you can create a synonym or the object it self.
to create a synonym
create synonym table1 for b.table1;
to create table itself
create table table1 as select * from b.table1;
Bala.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
