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!
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, 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...
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...
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?
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...
Large pool size
set in init.ora
large pool size =1M
after startup, and query large pool, why free memory is so big? (4294247976)
SQL> select * from v$sgastat
2 where pool='large pool';
POOL NAME BYTES
----------- -------------------------- ----------
large pool free memory 4294247976...
i can load image into table, and qurey the form successfully, but the form6i can not show the image in result. I have to copy and paste into other graphic application.
Question: is there any way can retrieve and read the image file without 9iAS/convert to HTML? Thanks.
Oracle9i on win2k server
Would like to know how to completely remove Names server?
I have removed Names.ora and some nameserver key in registry. (Some can not be deleted)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.