Tag Info

Hot answers tagged

5

When you add a column that is nullable and don't give a default value, the database doesn't have to do anything on the table data itself. The rows are unchanged, only the table metadata is altered. (This is due to the on-disk row format used. Null columns at the end of a row are not stored in the row pieces, in general/under normal circumstances/for ...


4

If you have a simple b-tree index on mycolumn, then yes, you would need to avoid calling functions on that column in order to be able to use the index to filter rows. In this case, it would seem to make much more sense to convert your numeric literals to timestamps than to do the reverse SELECT * FROM MYTABLE WHERE my_column > to_timestamp( ...


2

A DMP file is just a copy of the whole database contents. During the Import, it does not get modified, so you can use that file to "jump back" to the time when that dump file was created as often as you want.


2

Indexing Expressions I believe that the solution you are looking for pertains to building an index on an expression, rather than on the original data itself. For outside references, you can consult Wikipedia or the Oracle documentation, where the link here contains more info and subsequent links in the 'Function-Based Indexes' section. There are associated ...


1

Try this one: SELECT PRIV.id_extern_for_job , PRIV.id , PUB.id_extern_for_job FROM SOL_PUBLIC.SOL_SUBSOL_CHESTIONARE@RACDB PUB , SOL.SOL_SUBSOL_CHESTIONARE PRIV WHERE PRIV.id_extern_for_job = PUB.id AND PRIV.id <> PUB.id_extern_for_job;


1

The nice clean solution is to: install Oracle 11.2.0.3 on a new machine with the same machine name depending on your network putting the new one a different sub-net or in a fire walled zone could prevent network issues create an instance with the same name set the parameters and table spaces to be the same as the original import the data test, test, test ...


1

Yes, you need a script but it doesn't have to be 1000 lines. --make a table or global temporary table to put the results in CREATE TABLE TEMP_COLUMN_DATA ( PK_ID NUMBER(9), TABLE_SOURCE VARCHAR2(30), TEXT_CONTENT VARCHAR2(4000)); --add the primary key of PK_ID, are contents larger than 4000 characters? use a CLOB --create a trigger on the table if ...



Only top voted, non community-wiki answers of a minimum length are eligible