Home » RDBMS Server » Server Administration » need ahelp creating table (oracle 12c)
need ahelp creating table [message #612978] Mon, 28 April 2014 07:29 Go to next message
ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka
Junior Member
Am a database administrator want to create a table in some other schema for example create customer_detail table in cust schema how to do that...
Re: need ahelp creating table [message #612979 is a reply to message #612978] Mon, 28 April 2014 07:40 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ishan2ma wrote on Mon, 28 April 2014 07:29
Am a database administrator want to create a table in some other schema for example create customer_detail table in cust schema how to do that...


Seriously?
How about just looking at the CREATE TABLE syntax?

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7002.htm#SQLRF01402

In the syntax diagram notice the optional "schema" item.
Re: need ahelp creating table [message #612980 is a reply to message #612979] Mon, 28 April 2014 07:41 Go to previous messageGo to next message
ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka
Junior Member
i mean an assumption errr
Re: need ahelp creating table [message #612982 is a reply to message #612980] Mon, 28 April 2014 07:56 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ishan2ma wrote on Mon, 28 April 2014 07:41
i mean an assumption errr


I haven't the foggiest idea of what that is supposed to mean.
Re: need ahelp creating table [message #612983 is a reply to message #612982] Mon, 28 April 2014 08:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Previous Topic: Wait events
Next Topic: Adding disks to diskgroup
Goto Forum:
  


Current Time: Thu Mar 28 17:21:28 CDT 2024