Search results for query: *

Any one know is there any student guide for 1Z0-040 ? Any one has taken this test ? Please kindly share some exprience here. Thanks.

was: database 9.0.1.3.1 patch: 9.0.1.4.0 problem: after patch HTTPserver error, no entry point with OCI.dll. Even adjust the system path back to before patch, still HTTP server does not start. HELP!

After upgrading form6i to patch set 15, i can no longer start the net8 assistant and net8 easy config. It simply does not show up any GUI, how to fix?

When i import one table contents BLOB cloumn, the log shows IMP-00003: ORACLE error 22851 encountered ORA-22851: invalid CHUNK LOB storage option value I found the exported LOB storage chunk size is: CHUNK 65536 I can not import any row data into new database whatever i create the same...

Hi, i found when i use OLE to load the file into BLOB column in database, i can only retrieve it via OLE ??! If i retrieve the OLE stored file into OS file system via DBMS or HTTP gateway, i simply can not open it, and the fiile size is bigger than its original. Same thing as if i load the data...

Dear Sem, It works! I can insert new object into database and ,view it in form and retrieve it. however i still have question for the existing data in a table. (the table has many PDF/DOC files in one column, the data have been loaded into 9i database by DBMS package.) How i can view them or...

Hi, form 6i has nice feature let us load image, sound format files into database, but how form 6i can load other blob format (say dwg CAD format) into database by creating a trigger button? Or we have to load them through SQL*plus? I find that DBMS package does not work in form 6i enviroment...

Thanks, i have successfully patched the database as per the patch readme file.

Finally, have time to patch it and all is done. (though i use a lot http gateway to load blob recently.) Form 6i is real easy. Anyhow, after upgrade, it is strange the form6i's net8 assistant, and net8 easy config refuse to load. Anyone experienced the case?

Hi i have 9.0.1 database and would like to patch it from metalink patch sets. Should i install the sequence patch sets one by one? Or should i just install the latest one? Is there any known issues for the patch installation? Platform win2k server. I know i can only patch up to 9.0.1.X for...

Great! do you have patch set number? How many patches from 6.0.8.11.3? I will try it.

Yes, you need to have customer ID to download from metalink.oracle.com I am considering about form 9i or form 10g as Oracle recommend.

form6i should be able to display the BLOB column in table. but the version 6.0.8.11.3 can not load image into BLOB column by READ_IMAGE_FILE. (only long raw workable) Run form program, help/about, you can tell the version,as mine is: Forms [32 Bit] Version 6.0.8.11.3 (Production) Oracle Toolkit...

database oracle 8. current on Novel server, need to transfer into windows 2000 server, any special attention? Can i simply use Export/Import full? or RMAN?

Hi, i am using form 6i (6.0.8.11.3) and database 9.0.1. i have been using form 6i build-in READ_IMAGE_FILE to load file system images to tables with LONG RAW column for months. But i have no luck at all to save into BLOB cloumn although READ_IMAGE_FILE can display the image on form 6i image...

Database is shared server configuration. However serveral user use long batch. is it possible to config a special dedicated connection for them? can i simply assign a new port with server=dedicated in TNSname.ora?

Continue above question: If in 9i I set PGA_aggregate_target parameter, I can remove create_bitmap_area_size & bitmap_merge_area_size setting and save SGA memory by allocating BITMAP index memory usage into PGA?

when i set shared_pool=72M in init.ora and start the instance, it comes real shared_pool size as 88M at OEM, and i think the difference is coming from: - shared_pool_reserved_size - create_bitmap_area_size - bitmap_merge_area_size - sort_area_size (inside UGA???) - UGA size (v$sesstat join...

show parameter large; large_pool_size string 1048576 This is the right number setting in my init.ora, also from OEM i have the same result. Why v$sgastat gives wrong answer? (i logon / as sysdba) Yeh, i would like to know how oracle collects the SGA statistics.

Dear Sybaseguru, SQL> Show SGA; Total System Global Area 202141568 bytes Fixed Size 282496 bytes Variable Size 125829120 bytes Database Buffers 75497472 bytes Redo Buffers 532480 bytes I can not understand why v$sgastat has that result?