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...

Hi spenglerr, Below is what I did step by step to load an external PDF file into BFILE column. Please note that I already stored the PDF file (‘6117cdsapx.pdf’) on my Oracle server site at '/Disk05/test'.(my Oracle server 8.1.7 is running on Suse Linux 7.3 system), And also granted the...

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

Hi Turkbear, Below is what I did step by step. Please take a look at my procedure to see what did I do wrong. I am unable to view the content of the lobs column. Your help is greatly appreciated. Please note that I already stored my pdf file (6117cdsapx.pdf) on the Oracle server under...

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...

Hi Spenglerr, I just finished working on backup 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...

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