When we try to modify a datatype from varchar2(400) to Clob in a Oracle table, we’ll get the following error:
The following steps is the work-around to solve this issue:
ALTER TABLE SCHEMANAME.TABLENAME ADD NEWCOLUMN CLOB;
UPDATE SCHEMANAME.TABLENAME SET NEWCOLUMN = OLDCOLUMN;
ALTER TABLE SCHEMANAME.TABLENAME drop COLUMN OLDCOLUMN;
ALTER TABLE SCHEMANAME.TABLENAME rename COLUMN NEWCOLUMN TO OLDCOLUMN;
Hello,
In windows 7 - I want to search for all files containing "A word or phrase in the file". The standard XP search box, But I was not able to get the result until I did the following steps.
Hope it is helpful for people who is looking for the same feature.
Salam,
To this issue showed me stars!
We are using Devart dotconnect to connect to oracle database.
In the Dataset, in the Table adapter the max length is set to -1 by default. And in the Auto generated Abstract class the string datatype length is set to 1024 by default. Now to fix this if we change the max length column alone will not be sufficient. We need the rebuild the method again and then move the DataSet to production to make the changes come into effect!
Best Regards
SELECT T.TABLE_NAME,T.TABLESPACE_NAME,DF.FILE_NAME FROM DBA_TABLES T, DBA_DATA_FILES DF
SELECT T.TABLE_NAME,T.TABLESPACE_NAME,DF.FILE_NAME FROM DBA_TABLES T, DBA_DATA_FILES DF WHERE T.TABLESPACE_NAME = DF.TABLESPACE_NAME AND T.OWNER LIKE 'USER';
SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv
FROM table_privileges
WHERE grantee = <theUser>
ORDER BY owner, table_name;
I am looking for a SQL to find in tables in which a Column is present. The following SQL was helpful:
SELECT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%COL X%'
The Following SQL is helpful to list the size of All Schemas present in Oracle Database
select owner, sum(bytes)/1024/1024 tsize
from dba_segments
group by owner
order by tsize desc
Trust its helpful…
Regards
Fauzi
|
Hope you all are in good health. May almighty Allah shower us all with His blessings and guide us on the right & straight path, Aameen. | |
| ....:: 10. Yunus-Jonah (Makkah) ::.... | |
| Arabic | |
| WaAllahu yadAAoo ila darialssalami wayahdee man yashao ila siratinmustaqeemin | |
| TAMIL Translation | Allama A.K.Abdul Hameed Baagavi(Rah) | |
|
| |
| | |
| Malayalam Translation | Cheriyamudam Abdul Hammed Madani & Kunchi Muhammed Parapur | |
|
| |
| ENGLISH Translation – Dr. Muhammad Taqi-ud-Din Al-Hilali, Ph.D. & Dr. Muhammad Muhsin Khan | |
| [10:25] Allah calls to the home of peace (i.e. Paradise, by accepting Allah's religion of Islamic Monotheism and by doing righteous good deeds and abstaining from polytheism and evil deeds) and guides whom He wills to a Straight Path. | |
| ENGLISH TAFSIR - TAFSIR IBN ABBAS | |
|
| |
| URDU Translation | Dr. Col Muhammad Ayub | |
| | |
|
|
Following the syntaxes to create Sequence & Triggers
To Create Sequence:
===================
CREATE SEQUENCE "SchemaName"."Table1_LOG_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1
To Create Trigger:
==================
CREATE TRIGGER SchemaName.Table1_LOG_TRIGGER
BEFORE INSERT ON SchemaName.Table1_LOG
FOR EACH ROW
BEGIN
SELECT Table_LOG_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
Hi Reader,
I was looking for an online resource which can automatically generate styles for the tables which we create during web page development.
The following website was very much useful J
http://www.somacon.com/p141.php
Best Regards
Fauzi
--List the session that is blocking any object: for Monitoring
select O.object_name,O.object_type,S.sid,S.UserName,S.MACHINE, S.serial#,L.oracle_username,L.os_user_name,L.locked_mode
from dba_objects O,v$locked_object L,v$session S
where O.object_id = L.object_id and S.sid = L.session_id
Thanks & Regards
| Fauzi | |
