Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old July 31st, 2012, 04:56 AM
RAJ_55555's Avatar
RAJ_55555 RAJ_55555 is offline
Hats off to Mr. Joseph donahue
Dev Shed Novice (500 - 999 posts)
 
Join Date: Aug 2009
Posts: 749 RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 1 Week 6 Days 15 h 50 m 39 sec
Reputation Power: 1105
Precautions for converting a table field from long to clob

Hi guys,
I am more of a C/C++ guy and relatively amateur in oracle. I have to update a table field from "Long" to "CLOB". I have planned to do a simple alter table, and as far as I know there won't be any issues.

Queries:
1. Although I have triple checked, is there any scenario under which there can be any data loss during the data type change? The data is very critical and no data loss can be entertained.

2. Is there any easy way to update all the related views without having to do so manually?

3. Any particular precautions I should take before introducing the change?



Any help will be greatly appreciated. Thanks guys.

Reply With Quote
  #2  
Old July 31st, 2012, 12:57 PM
clivew clivew is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2006
Location: Carlsbad, CA
Posts: 2,045 clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level)clivew User rank is Major (30000 - 40000 Reputation Level) 
Time spent in forums: 1 Week 6 Days 2 h 37 m
Reputation Power: 382
Suggestions for questions:
Q1. There is the obvious "backup first" could be a proper backup or simply create
a temporary table with all the old data. Make sure you take care of the
storage specs for the altered column.
Q2. Depending upon what tools you use, I think many support you selecting items
(i.e. views) and doing a "Compile all with dependencies". Only caveat (and I am not
sure if it was Oracle). I have had situations where Instead of triggers
just get wiped away.
Q3. See Q2. regarding "instead of" triggers.

Reply With Quote
  #3  
Old August 1st, 2012, 12:12 AM
RAJ_55555's Avatar
RAJ_55555 RAJ_55555 is offline
Hats off to Mr. Joseph donahue
Dev Shed Novice (500 - 999 posts)
 
Join Date: Aug 2009
Posts: 749 RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level)RAJ_55555 User rank is General 2nd Grade (Above 100000 Reputation Level) 
Time spent in forums: 1 Week 6 Days 15 h 50 m 39 sec
Reputation Power: 1105
Thanks clivew for your reply. The triggers won't be a problem, as there are none.
To update the views i was looking at the refresh view proc, but if it can be done using an IDE I will look into it.

BTW anybody has any idea how to enter more than 60000 characters into a long field. I know the field can take the data, but can't find a way to enter the same.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Precautions for converting a table field from long to clob

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap