Home » SQL & PL/SQL » SQL & PL/SQL » Create table for other users (Oracle, SQLPlus)
Create table for other users [message #290444] Fri, 28 December 2007 23:27 Go to next message
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
Re: Create table for other users [message #290447 is a reply to message #290444] Fri, 28 December 2007 23:39 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

 create table user_name.table_name(....)



regards,
Re: Create table for other users [message #290572 is a reply to message #290447] Sun, 30 December 2007 00:12 Go to previous message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Thanks dhananjay,
That was so helpful.

Susu
Previous Topic: Rollback
Next Topic: ORA 1410
Goto Forum:
  


Current Time: Sun Dec 04 04:38:14 CST 2016

Total time taken to generate the page: 0.11392 seconds