BUFFER OVERFLOW, LIMIT OF 2000 BYTES.

Hi All, Below is a script to retrieve data from BFILE column and its output.The external PDF file is around 53, 435 bytes (text and picture altogether in one file). Anyone please have a fix for this script. I am unable to view the content of the external PDF file on the sreen. Any help is greatly

RE: BUFFER OVERFLOW, how to retrieve data from BFILE column

350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message-----From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 24, 2002 12:53 PMTo: Multiple recipients of list ORACLE-LSubject: BUFFER OVERFLOW, LIMIT OF 2000 BYTES. Hi All, Below is a sc

How to clone a local database from 9i server to a remote 8i server site

Hi All, Anyone please direct me where I can find good resources about how to clone a local database from Oracle9i server to a remote Oracle8i server site.Your help is greatly appreciated. Thanks in advance. LenkaDo You Yahoo!? HotJobs, a Yahoo! service - Search Thousands of New Jobs

RE: How to clone a local database from 9i server to a remote 8i s

Just wanted to have exact copy of my Oracle9i database serveron Suse Linux 7.3 on the remote Oracle8i database server. This is a very huge database (around 17 million records or so) needs to betransferred to the remote server. We are in planning process. The actual data is not readyto do

RE: How to clone a local database from 9i server to a remote 8i server

Hi All, Thank you all for your helpful information. I do appreciate it very much. I am working on it at the moment. Will need your input again very soon. Thanks Lenka Abdul Aleem <[EMAIL PROTECTED]>wrote: Perhaps: 1- Using materialized views on 8i Server from tables in 9i server. 2-

RE: How to clone a local database from 9i server to a remote 8i server

Hi All, Ireceived all good anwers and documentation from the list about using export/import utilities to transfer data between two different versions of databases.(Oracle9i 8i). Just wanted to know whether I do need to downgrade my Oracle9.0.2 database server to release 8.1.7 in order to make it

RE: How to clone a local database from 9i server to a remote 8i s

Hi Dennis, Thanks for your quick response. I do appreciate it very much. Unfortunately, I am not a person who can make a decision. Since my boss wants to go with the latest version of Oracle, so I amassigned to do research on this matter. Yes,I am currently running Oracle8.1.7 on my system. But

LOBs Questions. Need help.

Hi All, I want to load PDF files into the database and view the content of the lobs column. Below is what I did step by step. Anyone please point out what did I do wrong in my procedure. I am still unable to view the content of the Lobs column. I need you all for your help. Please note that I

How to create a directory alias on Suse Linux7.3 to insert an external PDF file into BFILE column.

Hi, I just wanted to create a directory alias on SuSe Linux7.3 in order to insert an external PDF file into BFILE column. Anyone please show me how to do so. On Window: CREATE or REPLACE DIRECTORY TEST as 'c:\images' ; On Linux: I issues this below command CREATE or REPLACE DIRECTORY TEST as

How to create Redo Log Members. Oracle8.1.7

Hi, I just wantedto create new online redo log members forexisting groups. Currently I have 3 online redo log groups. Each one contains only one member. Here is information about the online redo log of a database select group#, bytes, members from sys.v$log; GROUP# BYTES MEMBERS--

Re: How to create Redo Log Members. Oracle8.1.7.Thank You.

t;rdo" for redo logs, "ctl" for controlfiles,"dbf" for datafiles.You can use whatever you want and it does not have to be consistentwith what you used before. It's silly not to make it consistent but youcan do it--- Meomeo Nguyen <[EMAIL PROTECTED]>wrote: Hi, I just wanted t

Re: Database backup question.Thank You

forget anything, because RMAN will remember for you... Hope this helps... -Tim - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, May 23, 2002 5:33 PM Subject: Database backup question. Hi All, I need to perform a consistent backup for my whole

Re: Database backup question.Thank You

Thank you all for your responses.You all really confused me about this issue.The whole database backups can be consistentor inconsistent.To perform a consistent whole databse backup is the only valid backup option for databases running in NOARCHIVELOG mode. In contrast,an inconsistent backup is

how to change a foreign key back to a primary key

Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. TrangDo You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup

Re: how to change a foreign key back to a primary key

: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 7:05 PM Subject: how to change a foreign key back to a primary key Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo

RE: how to change a foreign key back to a primary key.Thank You.

constraint pk_TABLE_NAME primary key (COLUMN) using index tablespace indexes; -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 29, 2002 7:06 PMTo: Multiple recipients of list ORACLE-LSubject: how to change a foreign key back to a primary key Hi, I need

Simple Oracle database question.

Hi, Currently I have only one database running on a single host. Supposedly, I need to create multiple databases on the same host. My question is can I open two databases at the same time? I have not done it before, so just wanted to make sure that I can work on two databases all at once. Thanks

SQL*Loader question. Need a quick answer. Please

Meomeo Nguyen [EMAIL PROTECTED] wrote: Hi List,Below are my control and data files:(both files are stored on /Disk05)terminal.ctl file:LOAD DATAINFILE = ‘Disk05/terminal.dat’INTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”’(TERMINAL_POSITION_ID VARCHAR2 TERMINATED

Re: RV: SQL*Loader question. Need a quick answer. Please

- From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 4:49 PM Subject: SQL*Loader question. Need a quick answer. Please Meomeo Nguyen [EMAIL PROTECTED] wrote: Hi List,Below are my control and data files:(both files are stored on /Disk05)terminal.ctl

Alter command.Need urgent help.

Hi, I've worked on loading data into the database. By mistake, I havea typo intable attribute that needs to be fixed. Please help me how to write an sqlplus to correct my misspelled word or delete the generl_description attribute not the whole table. Here is an example of my table PART Part_id

Re: DATA TYPE question

Hi, I've tried to load data into a table with a data type number(5,3). For any reason, the system just rounded off the decimal number. It inserted the number 2 into the table instead of 1.5. Please direct me how to fix my problem. Your help is greatly appreciated. Thanks in advance. TrangDo You

Redo log files questions. Need help.

I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG.I then enabled automatic archiving of filled groups by setting log_archive_start=true in the database's parameter file. Finally I used alter system archive log start; to enable automatic archiving of filled online redo log

Re: Redo log files questions. Need help badly

Hi, Thanks for all the replies. I am still unable to archive my redo logs in order to back them up.When startup the database I then enter archive log list; Itshows archiving information for the coonected instance: Database log modeARCHIVELOG automatic archival DISABLED Archive destination

Re: Redo log files questions. Solved

Hi All, Finally, I have successfully had the automatic archiving turned on. My problem was I modified the wrong parameter file. Thus that caused the automatic archivalDISABLED. Regards, Trang Meomeo Nguyen [EMAIL PROTECTED] wrote: Hi, Thanks for all the replies. I am still unable to archive

Loading external binary files(PDF)into BLOB column. Urgent help.

Hi All, I've currently been working on loading many external binary files (PDF) intoBLOB column. After some digging, I learn that the SQL*LOADER can be used to load data from external files into table. I also got help from another forummate mentioning to use PL/SQL procedure to do so. Since I have