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
