Recent content by mrcomino

I really dont understand you. There are a lot of ways to generate a table i a oracle DB. You can create via - a SQL command SQL>Create table t1 (col1 number); - or via a script SQL>@table_creation.sql - or using some graphical tool that generate the SQL and execute it in a...

I have so much queries similar to select t1.c1,t1.c2,..., t2.c1,..., procedure_very_big(t1.c1,t4,c2) ,t4.c4 from t1 ,t2, t3, t4 where ...; rrrrr data rrrrrrr rrrrr data rrrrrr rrrrr data rrrrrr 3 rows selected The execution takes several minutes,even hours. And my question is Is...

The trace files are of shadow proceesses example: cat ora_22615.trc ... Redo thread mounted by this instance: 1 Oracle process number: 9 Unix process pid: 22615, image: oracleop73 *** SESSION ID:(7.251) 2001-04-05 23:09:55.755 Exception signal: 11, code = 1 ... *** 2001-04-05 23:09:55.827...

Hi Im using Oracle 7.3.4.5 over a Compaq Digital V4.0 D (878). Im getting more and more errors in the alert file. They are produced at night, just whe the cron is trying to shutdown the database after a full consistent export. For shutting down the DB, i use a changed version of oracle dbshut...

Im new in MS SqlServer , im using version 7. Its posible to have at the same time FK, and cascade update. I have created a FK between a parent and a child table, and i also created a triger update in the parent table in order to transmit any update of the parent to the child. But it doesnt...

Hi Im new in Oracle World and even more new in MS Sql-Server 7.0 . I want SQLServer not to check the validity of a constraint until the transaction is committed. it is veruy useful for DML sentences against related tables when you can not guarantee the order of the SQL-sentences inside the...

I have seen until 3.000.000 working properly, but the theorical limit must be higher.

If you dont need a recovery until the last committed transaction ,and if yor agree to recover only until your last full backup, then you can 1º delete all arc files that yor oracle is generating, and 2ºturn off the archive mode of your databse , the only thing you must notice is that you will...

So wide question for a forum. I recomend you to read some Oracle book. The main function of the arc files is to rollforward transactions (I mean execute again) after a full or partial recovery of your Database. All the transactions inside the arc files have been commited previously.

I have not write the document, and i cant remember whre I foud it, so perhaps it is not legal to publish it without authorization. Ill send you too, via mail.

I just have send you a Word document explaining the subject.

no time, so quickly The data dictionary of oracle store informatíon since the last startup of the instance, if your DB is shutingdown and startingup all days, perhaps you need to use AUDIT (prevoiusly you must run cataudit.sql,...) You also can use sqlnet-log, or even Operating system logs, I...

Nope Karluk ,it doesnt work. It sounded to nice to be true. Thanks for the try.

What i get is something like: select round(1.5),round(1.49999),round(1.5000001) from dual; ROUND(1.5) ROUND(1.49999) ROUND(1.5000001) ---------- -------------- ---------------- 2 1 2 What I need is something like: select...

to allow sharing positions ... SELECT A.TEAM, MIN(A.POSITION + B.POSITION + C.POSITION) FROM TEAMS A, TEAMS B, TEAMS C WHERE A.TEAM = B.TEAM AND B.TEAM = C.TEAM AND A.POSITION <= B.POSITION AND B.POSITION <= C.POSITION and A.rowid!=B.rowid and B.rowid!=C.rowid and A.rowid!=C.rowid...