Tag Info

New answers tagged

0

Thanks a lot, it helped me. I was not able to figure it out. Thanks !!!


0

In don't think you can use the resullt of a function. The documentation for the loader can be found in the Utilities Manual. Applying SQL Operators to Fields says The execution of SQL strings is not considered to be part of field setting. Rather, when the SQL string is executed it uses the result of any field setting (...) Field setting means that the ...


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 ...


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.


0

Use quotation marks: CREATE DATABASE LINK my_link CONNECT TO daniel identified by "*password" USING 'hostname:port/servicename';


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 ...


0

By default, Oracle will expire password after 180 days, so a highly probable cause of the high number of SHAD process is due to some connections using an expired password. For me, that connections was made from a web service constantly trying to make a connection. To fix the problem, you will need to update the password. If you want to stop password ...


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 ...



Top 50 recent answers are included