OraFAQ Forum: SQL & PL/SQL » Create table for other users

Home » SQL & PL/SQL » SQL & PL/SQL » Create table for other users (Oracle, SQLPlus)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create table for other users [message #290444]

Fri, 28 December 2007 23:27

susuOra
Messages: 10
Registered: December 2007
Location: USA

Junior Member

create table BOOKS (
Bcode varchar2(5),
Bname varchar2(5),
)
tablespace All;

If I have this script and would like to run it as a user who has a dba role but I want to create that table for another user. In other word, in another schema. How I would do that. What changes do I need to do with this script to make it works.

Thanks
Susu

Report message to a moderator

Re: Create table for other users [message #290447 is a reply to message #290444]

Fri, 28 December 2007 23:39

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

 create table user_name.table_name(....)

regards,

Report message to a moderator

Re: Create table for other users [message #290572 is a reply to message #290447]

Sun, 30 December 2007 00:12

susuOra
Messages: 10
Registered: December 2007
Location: USA

Junior Member

Thanks dhananjay,
That was so helpful.

Susu

Report message to a moderator

Previous Topic:	Rollback
Next Topic:	ORA 1410

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 21:02:31 CST 2024