Search results for query: *

Hi Karluk, Thanks for your response. For some reason, I did not receive any email notification for your answer. Sorry for not replying to your message any sooner.Welll, The procedure is not completing succesffuly. It created with compilation errors. Anyway, I don't need to retrieve the...

...displayBFILE_proc IS Lob_loc BFILE; Buffer RAW(1024); Amount BINARY_INTEGER := 1024; Position INTEGER := 1; BEGIN /* Select the LOB: */ SELECT book_file INTO Lob_loc FROM my_book_text WHERE file_desc = 'IBM Microprocessor'; /* Opening the BFILE: */...

Hi, Thanks for your response, Turkbear. I do appreciate it. I need you all for your help. Thanks Lenka.

...OR REPLACE PROCEDURE displayLOB_proc IS Lob_loc BLOB; Buffer RAW(1024); Amount BINARY_INTEGER := 1024; Position INTEGER := 1; BEGIN /* Select the LOB: */ SELECT m.Map_obj.Drawing INTO Lob_loc FROM Multimedia_tab m WHERE m.Clip_ID = 1; /* Opening the LOB is optional...

Thanks for your help, Turkbear. I will get back with you very soon. Thanks alot Lenka

Hi All, I used SQL*Loader to load an external PDF file into a database. I did successfully inserted PDF file into the database, I believe (due to not having any return error messages). However, After some digging, I found that SQL*Loader reacts to LOBs that can't be loaded in different...

Hi All, When using export/import utilities to transfer data between two different versions of databases. (Oracle9i & 8i), I need to reset the compatible initialization parameter in Oracle 9.0.2. Just wanted to know whether I do need to downgrade my Oracle9.0.2 database server to release 8.1.7...

Thanks for clarifying the information. YOu really give a better picture what I should do. Again, thanks for your great input. Have a good weekend. Lenka.

Thanks for your response, Karluk. Here is the web address to specify about Rogers's point to describe an actual problem. http://www.orafaq.com/archive/comp.databases.oracle.server/2001/12/30/129114.htm Since I have not done anything like this before, so I jsut wanted to educate myself before...

Hi Karluk, Thanks for your quick response. I do appreciate it. After some digging, I found that Howard J. Rogers said: "Import method will recreate all the indexes, so they are rebuilt and are not in the same state as they are in the source". So when Import/Export utility is used...

Clone means an exact copy. That is, I will copy a whole database from my production or test database from a local Oracle9i server to a remove Oracle8i server site. Currently, I plan to use Oracle9i server on Linux7.3 to develop a protocol for my project. However, my client is currently using...

Hi All, I plan to implement a new Oracle9i server system with dual proccessors. Can I clone a local database from Oracle9i server on Linux system to a remote Oracle8i server site? If so, How can I do that? Your help is greatly appreciated. Thanks in advance. Lenka

Hi All, I plan to implement a new Oracle9i server system with dual proccessors. Can I clone a local database from Oracle9i server to a remote Oracle8i server site? If so, How can I do that? Your help is greatly appreciated. Thanks in advance. Lenka

Hi Terry, Thanks for your very helpful information. I do appreciate it very much. Lenka

Hi All, Anyone please direct me how to import MDF and LDF files, which are stored on two different floppy disks into local SQL Server 2000. As a new user of SQL Server 2000, I also need your help to point me where I am able to get good online sources to educate myself. Your help is greatly...

Hi, I 've still struggled with this issue. For temperary use, can I upload pdf file (all text, no images)into a BLOB column by using sql*plus. If so, how can I view the contents of the BLOB as it can not be query-able. Please help. I do need you all for your help badly and urgently. Your...

HI Jee, Thanks for your information. I do appreciate it. Currently I've been working on LOBs. I will need you all your input as needed. Again, thanks a lot. th

Hi Spenglerr, Thanks for pointing me in the right direction. I do appreciate it. Well, I have to read and do more research about LOBs to educate myself to be familiar with LOBs. Since, I had installed downloaded Oracle8i on my computer from Oracle.com, so, I can't get an Oracle Documentation...

...task. Now I switch back working on loading LOB again. Just read the Oracle8i utilities, I then learn one thing that I can load LOBs by using sql*loader. I do appreciate your help, however, I barely understand the code you provided it as LOBs is very brand new to me. My question is what...

Hi All, Finally, I am able to have the automatic archiving turned on. By mistake, I modified the wrong init.ora file. Thus, it turned off the automatic archiving whenever I startup the database. Again, thanks for all your help. Best regards. Th