OraFAQ Forum: Server Administration » need ahelp creating table

Home » RDBMS Server » Server Administration » need ahelp creating table (oracle 12c)

Mon, 28 April 2014 07:29

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...

Mon, 28 April 2014 07:40

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.

Mon, 28 April 2014 07:41

ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka

Junior Member

i mean an assumption errr

Mon, 28 April 2014 07:56

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.

Mon, 28 April 2014 08:04

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: Sun Dec 22 05:33:00 CST 2024