Recent content by did02

I found the answer into Oracle Doc [party]: Stop Database Control Service Before Deinstalling. If you want to deinstall Oracle software or delete Database Control configuration, then Oracle recommends that you first stop the Database Control service (named OracleDBControlSID). This assures...

Hi all, Has anyone experienced to remove a monitored database from EM ? [sadeyes] What are the main steps (Oracle 10g on W2k3) ? - stop agent, - remove agent - remove $ORACLE_HOME\hostname_sid directory - remove oc4j instance - update $ORACLE_HOME\install\portlist.ini what else (config file...

Hi all, I have to determin the best way to copy a 200 Gb data running on Solaris 8 /Oracle 8.1.7 on a W2K / Oracle 8.1.7 plateform. I'm trying to know the used options on the source config (32/64b, MTS, parallele server) and come back as soon as possible. Any help would be appreciated...

Hi, In your insert statements, the value should be i (not 1)... :o) Rgds, Did02

Hi, As far as I know, you can install heterogeneous services on your oracle server to be able to create a DBLink between your oracle DB and another DB (not oracle). But I think it's easier to generate flat files (spooled queries) and load them in your SQL Server DB. Hope it's help. Rgds, Did02

Hi, I think it's possible. Do not forget to update the listner.ora and the tnsnames.ora on the server side and all tnsnames.ora, DSN files (ODBC),... on the client side. Rgds, Did02

Pdtt, Try this in your control file: LAST_VISIT DATE "MM/DD/YYYY" NULLIF reference_dt=' / / ', or LAST_VISIT CHAR "TO_DATE(DECODE(:LAST_VISIT, ' / / ',NULL, :LAST_VISIT),'MM/DD/YYYY')" , Both solutions should be ok. Rgds, Did02

Hi, You can use a decode in the control file to insert NULL : decode(field,' / / ',NULL,to_date(field,DD/MM/YY')) Hope it helps, Rgds, Did02

Hi, If there is no heavy queries for a while, you can drop indexes, coalesce the index TBS, recreate indexes (with new storage clauses) and analyze them with an online DB: it just decreases performances during these operations. Rgds, Did02

Hi Beantree, Is t3.record_date indexed ? If not, try to create an index. Compute (or estimate) statisitics and then try an explain plan again. Rgds, Did02

Hi Penzk001, As far as I know, the easiest way to backup you DB is to launch a script before (to stop your DB) and after (to restart your DB) the Legato backup. Then you just need to archive your datafiles. Nevertheless, It seems that sometimes, the Legato failed. It locks datafiles and you...

Hi David, Here is the difference of syntax : * first case : I don't know how your LOADPRODUCT string is executed, but I think the resolution of the connection uses the tnsnames.ora. So oracle access the DB through the network. Ex: sqlplus login/pwd@connect_string * second case : I think you...

Hi Bi, In your par file (or at the end of your command line) add these 2 parameters : LOG=/home/.../log/xxx.log BAD=/home/.../bad/xxx.bad Hope it helps. Did02

Hi Sweetleaf, I worked for a while with Datastage (on NT) + Oracle 8. Could you please tell me more about the job log. Rgds, Did02

Hi, Your code seems to be ok. But you can simplify it by using avg fonction : CREATE or REPLACE VIEW CUS_WEIGHTED_FAIRVALUE AS SELECT cf.GRANT_NUM FK_Grant_Number, avg((FAIR_VALUE*OPTS_VESTED)/OPTS_GRNTED) Weighted_Fair_Value FROM cus_fasb cf GROUP BY cf.GRANT_NUM It should give the same...