Tag Info

Hot answers tagged

5

My strong advice (regardless of the RDBMS): store the files separately. This makes a much smaller database, important when you backup, migrate, replicate etc. Additionally, you can separate db and files on different disks, having so much more control over storage locations (e.g. disk subsystems with different fail-over strategies). This means however, you ...


2

As per the comment, perhaps something like this: CREATE OR REPLACE PROCEDURE MYDB.GET_DEAL_LIST ( PersonID NUMBER, TableName NVARCHAR2, BuyerOrSeller INTEGER, a_CURSOR OUT sys_refcursor ) AS v_stmt_str VARCHAR2(200); BEGIN if BuyerOrSeller = 1 then v_stmt_str := 'SELECT TBLDEALS.*,t.* FROM TBLDEALS inner JOIN ' || tablename || ...


1

The oracle-rdbms-server-12cR1-preinstall package includes a bash script that creates the oracle user, if not already existing, using the useradd command. In this case in log file /var/log/oracle-rdbms-server-12cR1-preinstall/results/orakernel.log you should see this entry: Please set password for oracle user You can run the following command as root ...


1

You're unfortunately hitting bug 12999577 (Oracle support account required) or something close to it. And the fix for that bug introduced another bug 17564992. The workaround indicated in the first bug report is to switch the conditions around, i.e. express your where clause as 0 < ( ... ). The workaround indicated in the second is to set either of ...


1

$ORACLE_HOME/network/admin is the directory wwhere tnsnames.ora file is created by DBCA and/or NetCA. An OracleHome path like /u01/app ... is an OFA compliant path that the installler uses as default if not overriden by installer.


1

I completely agree with dartonw's comments about reading through the guide. That's the only real way to start understanding the concept of indexing as it relates to Oracle and the Optimizer. One thing I will add to it though is this - Philosophically, as a DBA, I rarely decide what columns to index on my own. What I mean by this is that I go back to the ...



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