Oracle
in [SQL]
|
RMAN Hi, We are running RMAN on 10gR2 without a recovery catalog. Everything will be running fine, maybe for days or weeks. Then RMAN comes up with errors like this: RMAN-06207: WARNING: 33 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command t... 22 Jun 2010 08:15
move database from sparc to linux Hi, i have to move a 10.2.0.3 database from solaris sparc to red hat linux. I see 4 possibilities 1. exp/imp 2. expdp/impdp 3. Transportable Tablespaces 4. Oracle Streams The first approach was expdp and was not succesful, because there are 400000 database objects in a 100GByte database. When i'm using... 22 Jun 2010 10:27
Oracle 10g : is possible return a sys ref cursor for sql from clob variable On Jun 18, 9:35 am, Santana <paulito.sant...(a)gmail.com> wrote: Hi, is possible a function return a sys ref cursor for sql from clob variable i ORACLE 10g, something like this : FUNCTION TEST AS RESULT SYS_REFCURSOR; L_QS CLOB ; BEGIN ..... OPEN result FOR TO_CHAR(... 18 Jun 2010 15:43
Urgent Requirement Hi, Here is urgent requirement. Please check the requirement and get to back me up dated profile, references(one should be citizen) and employer details. Title: JAVA Enterprise developer Location: NYC Duration: 2 years Description: JAVA Enterprise developer: JAVA Web developer with experience in developing J2E... 18 Jun 2010 13:31
Oracle 10g : is possible return a sys ref cursor for sql from clob variable Hi, is possible a function return a sys ref cursor for sql from clob variable i ORACLE 10g, something like this : FUNCTION TEST AS RESULT SYS_REFCURSOR; L_QS CLOB ; BEGIN ..... OPEN result FOR TO_CHAR(l_Qs); RETURN result ; END; The "l_qs" variable have a length like 40.... 18 Jun 2010 10:12
cluster_database_instances less than actual number of instance, any harm? All, We are trying to add one node to our RAC system (10.2.0.4) on linux. Our cluster_database_instances is set at 2, and we do not want to bounce our production database. We plan to keep it as 2 for a few month until we upgrade our Oracle. According to Oracle document, cluster_database_instances does not hav... 19 Jun 2010 04:47
Intuit outlook cloudy with a chance of BS. http://community.intuit.com/posts/server-down-4 http://intuit.apply2jobs.com/ProfExt/index.cfm?fuseaction=mExternal.showJob&RID=69637 http://community.intuit.com/letter-from-ceo-brad-smith Man oh man. Priorities. http://ww.uniontrib.com/uniontrib/20071013/news_1b13green.html My sympathies for anyone expec... 18 Jun 2010 00:26
Multiple Requirements Hi, Here are urgent requirements. Please check the requirements and get to back me as soon as possible with the following details and up dated profile. Position-1) Title: Micro strategy Consultant Location: Green bay, Wisconsin Duration:6+months Description: 6-10 years of experience in Microstrateg... 17 Jun 2010 13:23
Data Pump and GRANTs Hi I'm exporting with DataPump using SCHEMA=schemaname, and then I import into another database. The user I'm exporting has been granted EXECUTE on SYS.DBMS_CRYPTO in the source database. When I do the import, thus creating the schema into the other database, the imported user is not granted EXECUTE on S... 18 Jun 2010 06:56
:old.clob and :new.clob in triggers Hi, I've a table with a clob column. In a trigger that I need to write, I need to compare the old and new values for this column. The code inside the trigger body looks like this: CREATE OR REPLACE TRIGGER tr_clob_test AFTER INSERT OR UPDATE OR DELETE ON tbl_clob REFERENCING NEW AS NEW OLD AS OLD ... 19 Jun 2010 03:43 |