Home » SQL & PL/SQL » SQL & PL/SQL » External tables -alter table
External tables -alter table [message #266340] Mon, 10 September 2007 10:49 Go to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
Can external tables be altered?
If yes then pls provide an example.
Re: External tables -alter table [message #266345 is a reply to message #266340] Mon, 10 September 2007 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes or no, it depends on what you want to alter.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2104234

Regards
Michel
Re: External tables -alter table [message #266349 is a reply to message #266345] Mon, 10 September 2007 10:59 Go to previous messageGo to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
I wanted ti alter some column names and sizes.
Re: External tables -alter table [message #266350 is a reply to message #266349] Mon, 10 September 2007 11:06 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the link I posted, it describes all what you can do.

Regards
Michel
Previous Topic: Optimizing ALTER TABLE DDL statement
Next Topic: SQL*PLUS command
Goto Forum:
  


Current Time: Sun Dec 04 18:54:38 CST 2016

Total time taken to generate the page: 0.08764 seconds