Search results for query: *

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

Hi, The partition is an oracle option that exist since oracle 8. This option is very interesting to create (very) big tables : you define a partitionning key (with one or more fields of your table) and range values. For each range, oracle will create a "sub table" (ie a partition)...

Hi, To access an SQLServer DB from your oracle DB you have to implement heterogeneous services on your oracle serveur. For more information, read the oracle doc. I never tried it so I can't help you more. Rgds, Did02

Hi, First, the network_id_fk FK means that to insert a site with a given network_id, this network_id must exist in NETWORKS table (except if your foreign key is disabled). In other words, all network_id you'll find in SITE table exist in NETWORK table. This means that before populate your SITE...

Hi, Try something like this : declare fld1 number :=0; 'start value field1 inc_fld1 number :=5 ' increment for field1 fld2 date :=to_date('01/01/2003','DD/MM/YYYY'); 'start value field1 inc_fld2 number :=2 ' increment for field2 nb_rec number :=100; 'nb of insert begin for i...

Hi, As far as I know you will have to disable the foreign keys that reference fields from table1. So : - disable FK - create live_table1 as select * from table - truncate table1 - import data into table1 - clean up table1 - insert data from live_table1 into table1 (if needed) - drop...