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: 24
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

Report message to a moderator

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: 20098
Registered: January 2009
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/

Report message to a moderator

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: 24
Registered: October 2006
Junior Member
Thanks BlackSwan.
Jay

Report message to a moderator

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: 54167
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 22:31:59 CDT 2013

Total time taken to generate the page: 0.22534 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.