Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: change data_default Date: Fri, 08 Aug 2003 17:10:44 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <3f336f86$0$45864$91cee783@newsreader02.highway.telekom.at> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 19 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130376 On Fri, 8 Aug 2003 11:46:11 +0200, "Hubert Holler" wrote: >Can somebody tell me how I can change the data_default of a filed. >my table is called "media" and the filed is called "med_activ" and the >default value should be "1". > >Hope somebody can help me there. >Thanks a lot >Hubert > Just use the alter table modify command. NEVER EVER try to update the dictionary directly Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address