Home » RDBMS Server » Enterprise Manager » external tables Vs tables (Oracle 10g R 10.2.0)
external tables Vs tables [message #505115] Fri, 29 April 2011 08:54 Go to next message
parmarjm
Messages: 25
Registered: October 2006
Junior Member
Hi all,
What is the difference between CREATE EXTERNAL TABLE Vs CREATE TABLE .?

Is CREATE EXTERNAL TABLE included in CREATE TABLE?

Tx
JP
Re: external tables Vs tables [message #505117 is a reply to message #505115] Fri, 29 April 2011 09:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
table from CREATE EXTERNAL TABLE is READ ONLY while regular table can have DML done against it.

Unwilling or incapable to Read The Fine Manual yourself?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: external tables Vs tables [message #505119 is a reply to message #505117] Fri, 29 April 2011 09:05 Go to previous messageGo to next message
parmarjm
Messages: 25
Registered: October 2006
Junior Member
Thanks BlackSwan.
Jay
Re: external tables Vs tables [message #505121 is a reply to message #505115] Fri, 29 April 2011 09:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
external table
You can use this tool (in the link) for any of your question before posting it.

Regards
Michel

[Updated on: Fri, 29 April 2011 09:19]

Report message to a moderator

Previous Topic: Enterprise Console Message Interperation
Next Topic: OMS 11gR1 for POWER AIX 6.1
Goto Forum:
  


Current Time: Thu Mar 28 11:42:40 CDT 2024