RE: BUFFER OVERFLOW, how to retrieve data from BFILE column
Hi Karniotis, Thanks for your response. I do appreciate it. Well, after set serveroutput on size 6 or so and executing DBMS_OUTPUT.ENABLE(6), I am still unable to view the content of the BFILE column. There are a lot of garbage in the output. Anyone knows how to write a script to view data from the BFILE column, please help. Thanks Lenka "Karniotis, Stephen" <[EMAIL PROTECTED]>wrote: You need to execute DBMS_OUTPUT.ENABLE (buffer size); with a max of 100 bytes. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 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 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 appreciated. Thanks alot Lenka set serveroutput onDECLARE v_book_file BFILE; v_length NUMBER; v_position NUMBER; v_piece RAW (56,320);BEGIN SELECT book_file INTO v_book_file FROM my_book_text WHERE file_desc = 'testing'; dbms_lob.open (v_book_file, ); v_length := dbms_lob.getlength (v_book_file); v_position := 1; LOOP EXIT WHEN v_position > v_length; v_piece := dbms_lob.substr (v_book_file, 100, v_position); dbms_output.put_line (utl_raw.cast_to_varchar2(v_piece)); v_position := v_position + 100; END LOOP; dbms_lob.close (v_book_file);END;/=! ! = %PDF-1.3%bcOS1 0 obj<< /Creator6f007200640020>/CreationDate (D:19991019160202)/Title30031002e005000440046>/Author/Producer (AcrobatPDFWriter 4.0 for Windows)/ModDate (D:20001019200402+08'00')>> endobj2 0obj[ /PDF /Text /ImageB ]endobj3 0 obj<< /Pages 5 0 R /Type /Catalog /DefaultGray 31 0 R /DefaultRGB 32 0 R >> endobj4 0 obj<< /Type /Page /Parent 5 0 R /Resources << /Font << /F1 8 0 R/F2 10 0 R /F0 6 0R /F3 14 0 R /F4 16 0 R >> /ProcSet [ /PDF /Text /ImageB ] >> /Contents 57 0 R >> endobj5 0 obj << /Kids [ 4 0 R 18 0 R ] /Count 2 /Type /Pages /MediaBox [ 0 0 612 792 ] >> endobj6 0 obj<< /Type /Font /Subtype /TrueType /Name /F0 /BaseFont /Arial /FirstChar 31 /LastChar 255 /Widths [ 750 278 278 355 556 556 889 667 191 333 333 389 584 278 333 278 278 556556 556 556 556 556 556 556 556 556 278 278 584 584 584 556 1015 667 667 722 722 667 611 778 722 278500 667 556 833 722778 667 778 722 667 611 722 667 944 667 667 611 278 278 278 469 556 333 556556 500 556 556 278 556 556 222 222 500 222 833 556 556 556 556 333 500 278 556 500 722 500 500 500334 260 334 584 750 556 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500DECLARE*ERROR at line 1:ORA-2: ORU-10027: buffer overflow,! ! limit of 2000 bytesORA-06512: at "SYS.DBMS_OUTPUT", line 91ORA-06512: at "SYS.DBMS_OUTPUT", line 58ORA-06 5! ! 12: at line 17 Do you Yahoo!?New DSL Internet Access from SBC & Yahoo! The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!
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 appreciated. Thanks alot Lenka set serveroutput onDECLARE v_book_file BFILE; v_length NUMBER; v_position NUMBER; v_piece RAW (56,320);BEGIN SELECT book_file INTO v_book_file FROM my_book_text WHERE file_desc = 'testing'; dbms_lob.open (v_book_file, ); v_length := dbms_lob.getlength (v_book_file); v_position := 1; LOOP EXIT WHEN v_position > v_length; v_piece := dbms_lob.substr (v_book_file, 100, v_position); dbms_output.put_line (utl_raw.cast_to_varchar2(v_piece)); v_position := v_position + 100; END LOOP; dbms_lob.close (v_book_file);END;/== %PDF-1.3%bcOS1 0 obj<< /Creator6f007200640020>/CreationDate (D:19991019160202)/Title30031002e005000440046>/Author/Producer (AcrobatPDFWriter 4.0 for Windows)/ModDate (D:20001019200402+08'00')>> endobj2 0obj[ /PDF /Text /ImageB ]endobj3 0 obj<< /Pages 5 0 R /Type /Catalog /DefaultGray 31 0 R /DefaultRGB 32 0 R >> endobj4 0 obj<< /Type /Page /Parent 5 0 R /Resources << /Font << /F1 8 0 R/F2 10 0 R /F0 6 0R /F3 14 0 R /F4 16 0 R >> /ProcSet [ /PDF /Text /ImageB ] >> /Contents 57 0 R >> endobj5 0 obj << /Kids [ 4 0 R 18 0 R ] /Count 2 /Type /Pages /MediaBox [ 0 0 612 792 ] >> endobj6 0 obj<< /Type /Font /Subtype /TrueType /Name /F0 /BaseFont /Arial /FirstChar 31 /LastChar 255 /Widths [ 750 278 278 355 556 556 889 667 191 333 333 389 584 278 333 278 278 556556 556 556 556 556 556 556 556 556 278 278 584 584 584 556 1015 667 667 722 722 667 611 778 722 278500 667 556 833 722778 667 778 722 667 611 722 667 944 667 667 611 278 278 278 469 556 333 556556 500 556 556 278 556 556 222 222 500 222 833 556 556 556 556 333 500 278 556 500 722 500 500 500334 260 334 584 750 556 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500DECLARE*ERROR at line 1:ORA-2: ORU-10027: buffer overflow, limit of 2000 bytesORA-06512: at "SYS.DBMS_OUTPUT", line 91ORA-06512: at "SYS.DBMS_OUTPUT", line 58ORA-065! ! 12: at line 17Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!
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 '/Disk05/images' ; When using DBMS_LOB.fileexiststs function to test the existence of the file, but the specified fiel does not exist, Fileexists return zero. please note that I've already stored a specified file on /Disk05/images. Thanks in advance LenkaDo you Yahoo!? Yahoo! News - Today's headlines
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 already stored the PDF file (6117cdsapx.pdf) on my Oracle server site at /Disk05/test
CREATE TABLE MY_BOOK_TEXT (
FILE_DESC VARCHAR2 (200),
BOOK_FILE BFILE);
CREATE DIRECTORY TEST AS /Disk05/test;
DECLARE
pdf BFILE;
BEGIN
pdf := BFILENAME (TEST, 6117cdsapx.pdf);
END;
/
INSERT INTO MY_BOOK_TEXT (FILE_DESC, BOOK_FILE )
VALUES (IBM Microprocessor, BFILENAME(TEST, 6117cdsapx.pdf);
This procedure has been executed on the server site. When executing the procedure, it got a warning message: Procedure created with compilation errors.
CREATE 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: */ DBMS_LOB.OPEN (Lob_loc, DBMS_LOB.LOB_READONLY); LOOP DBMS_LOB.READ (Lob_loc, Amount, Position, Buffer); /* Display the buffer contents: */ DBMS_OUTPUT.PUT_LINE(utl_raw.cast_to_varchar2(Buffer)); Position := Position + Amount; END LO!
OP; /* Closing the LOB is mandatory if you have opened it: */ DBMS_LOB.CLOSE (Lob_loc); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('End of data'); End;/
Thank you all for your help in advance
LenkaYahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
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 am assigned to do research on this matter. Yes, I am currently running Oracle8.1.7 on my system. But this server is only serving as a development database. Therefore, I had installed the downloaded Oracle software from Oracle.com on my system and it works very well. Now, I need to set up a brand new production database with an Oracle license in order to load very huge data on it before tranferring to the remote Oracle8.1.7 server site. Since I have not done anything like this before, so I really spend a lot of time to work on the compatibility issues. To make this matter simple, of course Oracle 8.1.7 database is perfect match with my client's server. But, I am not in the position to make it happen. Will see if I can convince my boss to change his mind. Any help is greatly appreciated. Again, thanks for your input. Lenka DENNIS WILLIAMS <[EMAIL PROTECTED]>wrote: Nguyen - If your client is important to you, why not install 8.1.7 on yoursystem? You can run two instances on almost every system today. Then youwill have fewer compatibility issues and serve your client better.Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Monday, August 26, 2002 6:58 PMTo: Multiple recipients of list ORACLE-LserverHi All,I received all good anwers and documentation from the list about usingexport/import utilities to transfer data between two different versions ofdatabases. (Oracle9i & 8i). Just wanted to know whether I do need todowngrade my Oracle9.0.2 database server to release 8.1.7 in order to makeit compatible with my client's server or not? I plan to set up a brand new Oracle9.0.2 server very soon. Just wanted toseek y! ! our good advice of which version of oracle (9.0.2 or 8.1.7) I shouldgo for. Since I read the documentation on this linkhttp://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96530/downgrad.htm#10088790/a96530/downgrad.htm#1008879> and found that it is not fun at all to downgrade the entire Oracle9.0.2 inorder to work with my remote Oracle8.1.7 server. Please direct me what todo. Your help is greatly appreciated.Thanks in advance.LenkaJust wanted to have exact copy of my Oracle9i database server on Suse Linux7.3 on the remote Oracle8i database server. This is a very huge database(around 17 million records or so) needs to be transferred to the remoteserver. We are in planning process. The actual data is not ready to do so.Therefore, I don't know how often the data needs to be transferred. We areon the process to buy a new server with dual processors to store this hugedat! ! a. And, we also wanted to go with Oracle9i EE while our client iscurrently using Oracle8i. For this reason, programming languages and toolsto be used for development must be supported by and compatible with Oracleversion 8.1.7. Hope it answers your questions.Thanks for your response. I do appreciate it.Have a good weekend.Lenka.DENNIS WILLIAMS wrote: Lenka - Perhaps you can explain your requirements in a little more detail.Here are some questions that occur to me:- What do you mean by "clone" specifically. Do you mean you have somedata in one or more tables you wish to move? Are you thinking you can movedatafiles themselves? Have you investigated transportable tablespaces?- How much data is involved? A few gigabytes? A few megabytes? Thesolutions vary dramatically by size. If it is just a little data, justexport and import the data.- How often do you need to move this data? Only once? D! ! aily? Hourly?I'm tired and going home for the weekend, but with more specifics you mayreceive some responses during the weekend.Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Friday, August 16, 2002 12:44 PMTo: Multiple recipients o! ! f list ORACLE-LsiteHi All,Anyone please direct me where I can find good resources about how to clone alocal database from Oracle9i server to a remote Oracle8i server site. Yourhelp is greatly appreciated.Thanks in advance.Lenka_ Do You Yahoo!?HotJobs, a Yahoo! service - Search Thousands of New Jobs-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Maili! ! ng ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to b! ! e removed from). You mayalso send the HELP command for other information (like subscribing)._ Do You Yahoo!?Yahoo! Finance - Get real-time stock quotes-- Please see the offici
RE: How to clone a local database from 9i server to a remote 8i server
Hi All, I received 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 compatible with my client's server or not? I plan to set up a brand new Oracle9.0.2 server very soon. Just wanted to seek your good advice of which version of oracle (9.0.2 or 8.1.7) I should go for. Since I read the documentation on this link http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96530/downgrad.htm#1008879 and found that it is not fun at all to downgrade the entire Oracle9.0.2 in order to work with my remote Oracle8.1.7 server. Please direct me what to do. Your help is greatly appreciated. Thanks in advance. Lenka Just wanted to have exact copy of my Oracle9i database server on Suse Linux 7.3 on the remote Oracle8i database server. This is a very huge database (around 17 million records or so) needs to be transferred to the remote server. We are in planning process. The actual data is not ready to do so. Therefore, I don't know how often the data needs to be transferred. We are on the process to buy a new server with dual processors to store this huge data. And, we also wanted to go with Oracle9i EE while our client is currently using Oracle8i. For this reason, programming languages and tools to be used for development must be supported by and compatible with Oracle version 8.1.7. Hope it answers your questions. Thanks for your response. I do appreciate it. Have a good weekend. Lenka. DENNIS WILLIAMS <[EMAIL PROTECTED]>wrote: Lenka - Perhaps you can explain your requirements in a little more detail.Here are some questions that occur to me:- What do you mean by "clone" specifically. Do you mean you have somedata in one or more tables you wish to move? Are you thinking you can movedatafiles themselves? Have you investigated transportable tablespaces?- How much data is involved? A few gigabytes? A few megabytes? Thesolutions vary dramatically by size. If it is just a little data, justexport and import the data.- How often do you need to move this data? Only once? Daily? Hourly?I'm tired and going home for the weekend, but with more specifics you mayreceive some responses during the weekend.Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Friday, August 16, 2002 12:44 PMTo: Multiple recipients o! ! f list ORACLE-LsiteHi All,Anyone please direct me where I can find good resources about how to clone alocal database from Oracle9i server to a remote Oracle8i server site. Yourhelp is greatly appreciated.Thanks in advance.Lenka_ Do You Yahoo!?HotJobs, a Yahoo! service - Search Thousands of New Jobs-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to b! ! e removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes
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- Connecting from 8i server to 9i server, taking backup (exp) of 9i Server, from 8i server and restoring it on 8i server. HTH! Aleem -Original Message-From: Straub, Dan [mailto:[EMAIL PROTECTED]]Sent: Saturday, August 17, 2002 1:28 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to clone a local database from 9i server to a remote 8i s > > 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. > See the "export/import" documentation and Metalink # 61949.1 Dan. Do 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 server on Suse Linux 7.3 on the remote Oracle8i database server. This is a very huge database (around 17 million records or so) needs to be transferred to the remote server. We are in planning process. The actual data is not ready to do so. Therefore, I don't know how often the data needs to be transferred. We are on the process to buy a new server with dual processors to store this huge data. And, we also wanted to go with Oracle9i EE while our client is currently using Oracle8i. For this reason, programming languages and tools to be used for development must be supported by and compatible with Oracle version 8.1.7. Hope it answers your questions. Thanks for your response. I do appreciate it. Have a good weekend. Lenka. DENNIS WILLIAMS <[EMAIL PROTECTED]>wrote: Lenka - Perhaps you can explain your requirements in a little more detail.Here are some questions that occur to me:- What do you mean by "clone" specifically. Do you mean you have somedata in one or more tables you wish to move? Are you thinking you can movedatafiles themselves? Have you investigated transportable tablespaces?- How much data is involved? A few gigabytes? A few megabytes? Thesolutions vary dramatically by size. If it is just a little data, justexport and import the data.- How often do you need to move this data? Only once? Daily? Hourly?I'm tired and going home for the weekend, but with more specifics you mayreceive some responses during the weekend.Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Friday, August 16, 2002 12:44 PMTo: Multiple recipients o! ! f list ORACLE-LsiteHi All,Anyone please direct me where I can find good resources about how to clone alocal database from Oracle9i server to a remote Oracle8i server site. Yourhelp is greatly appreciated.Thanks in advance.Lenka_ Do You Yahoo!?HotJobs, a Yahoo! service - Search Thousands of New Jobs-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containin! ! g: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? HotJobs, a Yahoo! service - Search Thousands of New Jobs
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
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 in advance TrangDo You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup
RE: how to change a foreign key back to a primary key.Thank You.
Richard and Igor, Thank you both for your quick answers. I do appreciate it very much. The statements work well. Again, thanks for your help. Trang Richard Huntley <[EMAIL PROTECTED]> wrote: Trang, How about: alter table TABLE_NAME drop constraint CONSTRAINT_NAME; alter table TABLE_NAME add 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 to change a foreign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World Cup Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup
Re: how to change a foreign key back to a primary key
Hi Igor, I just wanted to set a concatenated keys for my table. By mistake, I assigned only one primary key instead of two combined together. Here is my table structure: organization_id (primary key) address_id (foreign key) It should have been a primary key as well. I wanted to set this attribute as primary key. How do I do that? address_type Thanks for your help. I do appreciate it. Trang Igor Neyman <[EMAIL PROTECTED]> wrote: Trang, Could you be a little bit more specific about what you are trying to do? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: 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 a foreign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World CupDo You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup
how to change a foreign key back to a primary key
Hi, I need to change a foreign 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: 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 consistent or 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 valid if the database is running in ARCHIVELOG mode. So, my question is why having my databse running in the ARCHIVELOG mode, I can still perform both consistent and inconsistent backup options? Steve posted : "I don't understandy why you would switch to and from archivelog mode. You can establish a complete cold backup with your datafiles, control files, and online redo logs. Actually you don't need the online redo logs, but that used to be the case so I always back those up as well. Shut your DB down (normal), and back these files up. That is a complete cold backup." Steve, I switch to and from archivelog mode because the best way to back up the contents of the current online redo log is always to archive it, then back up the archived logs. Again, I do appreciate you all for your help. I do need very clear picture about this issue. Since I have not done anything like this before so I do need your feedback badly. Thanks in advance Trang Gene Sais <[EMAIL PROTECTED]> wrote: my backup strategy, fwiw:prod - cold monthly, hot 2x week, exp weekly.test - cold, hot, exp occassional, always can refresh from prod.dev - cold & hot occassional, exp daily.all dbs are in archivelogmode!gene>>> [EMAIL PROTECTED] 05/24/02 03:04PM >>>lets not forget the classic "exp".1. Production database (where you can't lose a singletransaction) - ARCHIVEMODE absolutely2. Development database (few hrs of transactions ok tolose) - cold backups3. Development database (no schema changes, say anapplication is being developed with a tool such asusing Oracle designer) - a simple 'exp un/pwd' of theuser, is the simplest, quickest, lightest, leastheadache,... may also be considered.KeithDate: Fri, 24 May 2002 09:12:02 -0800 To! ! : "Multiple recipients of list ORACLE-L"<[EMAIL PROTECTED]>Reply-to: [EMAIL PROTECTED] Address | Add to Address Book Organization: Fat City Network Services, San Diego,California Hi Tim and Connor, Thanks you all for your very helpful feedback. I doappreciate it very much. In fact, we are indevelopment at this point, so the database is smalland transaction volume is very low. Therefore, mychoice for primary backup method is the cold backups. However, to safeguard against unsual things, whichmight happen to the database, I will take your adviceto run my database in ARCHIVELOG mode. The hot backupwill be used. Again, thanks for your very quickresponses. Regards, Trang Tim Gorman <[EMAIL PROTECTED]>wrote: Trang,Theoretically, the online redo log files are benecessary, but the world has a habit of making ashambles of the theoretical. Let's say, in the e! ! ventthat you automate your Friday script, you'll probablycome to realize that SHUTDOWN IMMEDIATE is far fromperfect (as well as far from immediate!). Over time,you'll probably construct some kind of "fail-safe"mechanism to SHUTDOWN ABORT if the initial SHUTDOWNIMMEDIATE doesn't shut down after a period of time. Pretty standard thing that DBAs have been writing foryears. Hopefully, after the SHUTDOWN ABORT they alsoSTARTUP RESTRICT and then SHUTDOWN NORMAL, but youcan't count on it...So, here's the point: what if you take a cold backupin NOARCHIVELOG mode after a SHUTDOWN ABORT (thatshould have been a SHUTDOWN IMMEDIATE and wasn't) andyou have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: alldatafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the pointof excluding them?It is wise to take a cold backup afte! ! r a cleanshutdown, but you can even get a valid backup after aSHUTDOWN ABORT or a crash if you've backed up theonline redo archive log files. When you restartOracle, an instance recovery will occur automatically,and you might not even know it. Just be certain thatthe instance is truly "dead" when you take your "cold"backup...With regards to switching between ARCHIVELOG andNOARCHIVELOG, it's a waste of effort from arecoverability standpoint. At most it may beinteresting, but as soon as you switch out ofARCHIVELOG mode, nothing you've done while inARCHIVELOG mode is valid anymore. Leave it one way orthe other, and then leave it..just my $0.02...Another $0.02: use RMAN for your cold backups. Thenyou won't forget anything, because RMAN will rememberfor you...Hope this helps...-Tim- Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, Ma! ! y 23, 2002 5:33 PMHi All,I need to perform a consistent backup for my wholedatabase every Friday by using operating systemutilities. My database has been currently operatingin NOARCHIVELOG mode, so the only files need to bebacked up are datafiles, control files, theinitialization parameter file and
Re: Database backup question.Thank You
Hi Tim and Connor, Thanks you all for your very helpful feedback. I do appreciate it very much. In fact, we are in development at this point, so the database is small and transaction volume is very low. Therefore, my choice for primary backup method is the cold backups. However, to safeguard against unsual things, which might happen to the database, I will take your advice to run my database in ARCHIVELOG mode. The hot backup will be used. Again, thanks for your very quick responses. Regards, Trang Tim Gorman <[EMAIL PROTECTED]> wrote: Trang, Theoretically, the online redo log files are be necessary, but the world has a habit of making a shambles of the theoretical. Let's say, in the event that you automate your Friday script, you'll probably come to realize that SHUTDOWN IMMEDIATE is far from perfect (as well as far from immediate!). Over time, you'll probably construct some kind of "fail-safe" mechanism to SHUTDOWN ABORT if the initial SHUTDOWN IMMEDIATE doesn't shut down after a period of time. Pretty standard thing that DBAs have been writing for years. Hopefully, after the SHUTDOWN ABORT they also STARTUP RESTRICT and then SHUTDOWN NORMAL, but you can't count on it... So, here's the point: what if you take a cold backup in NOARCHIVELOG mode after a SHUTDOWN ABORT (that should have been a SHUTDOWN IMMEDIATE and wasn't) and you have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: all datafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the point of excluding them? It is wise to take a cold backup after a clean shutdown, but you can even get a valid backup after a SHUTDOWN ABORT or a crash if you've backed up the online redo archive log files. When you restart Oracle, an instance recovery will occur automatically, and you might not even know it. Just be certain that the instance is truly "dead" when you take your "cold" backup... With regards to switching between ARCHIVELOG and NOARCHIVELOG, it's a waste of effort from a recoverability standpoint. At most it may be interesting, but as soon as you switch out of ARCHIVELOG mode, nothing you've done while in ARCHIVELOG mode is valid anymore. Leave it one way or the other, and then leave it... ...just my $0.02... Another $0.02: use RMAN for your cold backups. Then you won't 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 database every Friday by using operating system utilities. My database has been currently operating in NOARCHIVELOG mode, so the only files need to be backed up are datafiles, control files, the initialization parameter file and other oracle product initialization files (Based on Oracle8.1.6 Backup and Recovery Guide). Since the files in this type of backup are all consistent and do not need recovery, so the online logs are not needed. Since online redo logs is very crucial for recovery, so my question is do I need to back up the online redo log files as I choose to perform cold backup type for my entire database weekly? Here is step by step what I did to back up the whole database: after the database was closed cleanly and all the above mentioned files had been backed up into the tape. I had to restart the database and mount but not open, then switched between NOARCHIVELOG mode to ARCHIVELOG mode in order to archive the online redo log files. Finally, I copied all archived redo log files into the tape while the database was open and operated in ARCHIVELOG mode. when it was all done, I then switched the database back to NOARCHIVELOG mode. Just wondered whether my procedure to perform a whole consistent database backup is correct? Am I safe to this point? Your help is greatly appreciated it. Your help is greatly appreciated. Thanks in advance, Trang Do You Yahoo!?LAUNCH - Your Yahoo! Music ExperienceDo You Yahoo!? LAUNCH - Your Yahoo! Music Experience
Re: How to create Redo Log Members. Oracle8.1.7.Thank You.
Hi Rachel and Mike, Thank you for your quick responses. I do appreciate it. Regards, Trang Rachel Carmichael <[EMAIL PROTECTED]> wrote: redo log file extensions (in fact, any file extension) are not fixed bythe database but are whatever you want them to be.Oracle uses a standard of "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 to create new online redo log members for existing> 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> -- -- --> 1 512000 1> 2 512000 1! ! > 3 512000 1> > > select * from sys.v$logfile where group# = 1;> > > GROUP# STATUS MEMBER> -- --->-> 1 /Disk01/app/oradata/ttdb/redo01.log> > select * from sys.v$logfile where group# = 2;> > > GROUP# STATUS MEMBER> -- --->-> 2 /Disk01/app/oradata/ttdb/redo02.log> > select * from sys.v$logfile where group# = 3;> > > GROUP# STATUS MEMBER> -- --->--! ! ---> 3 /Disk01/app/oradata/ttdb/redo03.log> > > > > After reading the Database Administrator's Guide about how to create> online redo log members, I am a little bit confused about the file> extension for online redo log files. To create new online redo log> members for an existing group, use the > > alter database add logfile member '/oracle/dbs/log2b.rdo' to group 1;> (From Orcle8.1.6 Administrator's Guide). > > Based on my query information, member of group 1 is> /Disk01/app/oradata/ttdb/redo01.log. My question is why the> extension of the member of my redo log file is .log, which is> different from the Oracle Administrator's Guide's above example?Here> is my SQL statement to create redo log member for each existing> group.> > alter! ! database add logfile member '> /Disk02/app/oradata/ttdb/redo01a.log to group 1; /* I place this> member of group 1 in different location. > > Just wondered whether this is a correct statement to create online> redo log member. If not, please show me how to fix it. Please help.> > I want to add new online redo log member for existing groups because> I want to safeguard against a single point of online redo log> failure.> > Thanks in advance.> > Trang> > > > -> Do You Yahoo!?> LAUNCH - Your Yahoo! Music Experience__Do You Yahoo!?LAUNCH - Your Yahoo! Music Experiencehttp://launch.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rachel CarmichaelINET: [EMAIL PROTECTED]Fat City Networ! ! k Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience
How to create Redo Log Members. Oracle8.1.7
Hi, I just wanted to create new online redo log members for existing 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-- -- -- 1 512000 1 2 512000 1 3 512000 1 select * from sys.v$logfile where group# = 1; GROUP# STATUS MEMBER-- --- - 1 /Disk01/app/oradata/ttdb/redo01.log select * from sys.v$logfile where group# = 2; GROUP# STATUS MEMBER-- --- - 2 /Disk01/app/oradata/ttdb/redo02.log select * from sys.v$logfile where group# = 3; GROUP# STATUS MEMBER-- --- - 3 /Disk01/app/oradata/ttdb/redo03.log After reading the Database Administrator's Guide about how to create online redo log members, I am a little bit confused about the file extension for online redo log files. To create new online redo log members for an existing group, use the alter database add logfile member '/oracle/dbs/log2b.rdo' to group 1; (From Orcle8.1.6 Administrator's Guide). Based on my query information, member of group 1 is /Disk01/app/oradata/ttdb/redo01.log. My question is why the extension of the member of my redo log file is .log, which is different from the Oracle Administrator's Guide's above example?Here is my SQL statement to create redo log member for each existing group. alter database add logfile member ' /Disk02/app/oradata/ttdb/redo01a.log to group 1; /* I place this member of group 1 in different location. Just wondered whether this is a correct statement to create online redo log member. If not, please show me how to fix it. Please help. I want to add new online redo log member for existing groups because I want to safeguard against a single point of online redo log failure. Thanks in advance. TrangDo You Yahoo!? LAUNCH - Your Yahoo! Music Experience
Loading external binary files(PDF)into BLOB column. Urgent help.
Hi All, I've currently been working on loading many external binary files (PDF) into BLOB 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 not done anything like this before. So, my question is what is the simple approach needed to upload PDF files into a table(there is only one table containing BLOB column in my database). In addition, the LOBs can not be query-able, I wanted to list the contents of the LOBs column to make sure that I did successfully upload data into the database. How can I do that?. I do need your help. Please direct me step by step how to do so. Your help is greatly appreciated. Regards, TrangDo You Yahoo!? LAUNCH - Your Yahoo! Music Experience
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 archival DISABLED. Regards, Trang Meomeo Nguyen <[EMAIL PROTECTED]> wrote: 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; It shows archiving information for the coonected instance: Database log mode ARCHIVELOG automatic archival DISABLED Archive destination /Disk01/app/oracle/product/8.1.7/dbs/arch (Please note: there is no arch directory or files in this path) oldes online log sequence 1629 next log sequence to archive 1631 current log sequence number 1631 Please note: I did uncomment the log_archive_start=true in the init.ora file. How do I set archiving destination with log_archive_dest and log archive format. Below is the information from my init.ora. I have not uncommented these two paths yet. log_archive_dest =disk$rdbms:[oracle.archive] (Please note: if I set archiving destination log_archive_dest='/Disk05/arc', how do I alter the parameter for the below log_archive_format? ) log_archive_format = "T%TS%S.ARC" in the init.ora file. Please anyone direct me how to make it work. I do need your help badly. Thanks in advance. Trang Gene Sais <[EMAIL PROTECTED]> wrote: You probably received an error in your alert log and Oracle disabled archiving. Make sure yuou have these 3 parameters in your init.ora and set accordingly:log_archive_dest = /oracle/data/arc//log_archive_format = _%s.arclog_archive_start = truehth,Gene>>> [EMAIL PROTECTED] 05/10/02 06:08PM >>>I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then enabled automatic archiving of filled groups by settinglog_archive_start=truein the database's parameter file. Finally I used alter system archive log start; to enable automatic archiving of filled online redo log group without shutting down the current instance. For some reason, when using the SQL*Plus statementarchive log list;it shows the archiving information for the connected instance:! ! ! ! database log mode ARCHIVELOGautomatic archival ENABLED..etcBut when I shutdown immediate then startup the instance with database open, I then issue the archive log list; this time the automatic archival DISABLED. Anyone came across this problem and had a fix. Please direct me how to fix it. I just wanted to archive online logs to multiple locations, then back up the archived logs. Please help.Thanks in advance. Your help is greatly appreciated.Trang-Do You Yahoo!?Yahoo! Shopping - Mother's Day is May 12th!--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gene SaisINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMO! ! VE y! ! ourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?LAUNCH - Your Yahoo! Music ExperienceDo You Yahoo!? LAUNCH - Your Yahoo! Music Experience
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; It shows archiving information for the coonected instance: Database log mode ARCHIVELOG automatic archival DISABLED Archive destination /Disk01/app/oracle/product/8.1.7/dbs/arch (Please note: there is no arch directory or files in this path) oldes online log sequence 1629 next log sequence to archive 1631 current log sequence number 1631 Please note: I did uncomment the log_archive_start=true in the init.ora file. How do I set archiving destination with log_archive_dest and log archive format. Below is the information from my init.ora. I have not uncommented these two paths yet. log_archive_dest =disk$rdbms:[oracle.archive] (Please note: if I set archiving destination log_archive_dest='/Disk05/arc', how do I alter the parameter for the below log_archive_format? ) log_archive_format = "T%TS%S.ARC" in the init.ora file. Please anyone direct me how to make it work. I do need your help badly. Thanks in advance. Trang Gene Sais <[EMAIL PROTECTED]> wrote: You probably received an error in your alert log and Oracle disabled archiving. Make sure yuou have these 3 parameters in your init.ora and set accordingly:log_archive_dest = /oracle/data/arc//log_archive_format = _%s.arclog_archive_start = truehth,Gene>>> [EMAIL PROTECTED] 05/10/02 06:08PM >>>I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then enabled automatic archiving of filled groups by settinglog_archive_start=truein the database's parameter file. Finally I used alter system archive log start; to enable automatic archiving of filled online redo log group without shutting down the current instance. For some reason, when using the SQL*Plus statementarchive log list;it shows the archiving information for the connected instance:! ! database log mode ARCHIVELOGautomatic archival ENABLED..etcBut when I shutdown immediate then startup the instance with database open, I then issue the archive log list; this time the automatic archival DISABLED. Anyone came across this problem and had a fix. Please direct me how to fix it. I just wanted to archive online logs to multiple locations, then back up the archived logs. Please help.Thanks in advance. Your help is greatly appreciated.Trang-Do You Yahoo!?Yahoo! Shopping - Mother's Day is May 12th!--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gene SaisINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE y! ! ourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience
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 group without shutting down the current instance. For some reason, when using the SQL*Plus statement archive log list; it shows the archiving information for the connected instance: database log mode ARCHIVELOG automatic archival ENABLED ..etc But when I shutdown immediate then startup the instance with database open, I then issue the archive log list; this time the automatic archival DISABLED. Anyone came across this problem and had a fix. Please direct me how to fix it. I just wanted to archive online logs to multiple locations, then back up the archived logs. Please help. Thanks in advance. Your help is greatly appreciated. TrangDo You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th!
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 Yahoo!? Yahoo! Games - play chess, backgammon, pool and more
Alter command.Need urgent help.
Hi, I've worked on loading data into the database. By mistake, I have a typo in table 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 operating_range generl_description (should be general_description) mass .. Thanks in advance. Trang Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more
Re: RV: SQL*Loader question. Need a quick answer. Please
Hi All, Thanks for all the replies. I do appreciate it. Finally, I successfully loaded data into the database, thanks to all your help. Trang Natalia Laracca <[EMAIL PROTECTED]> wrote: Hi, First, in a test' database, I would do: terminal.ctl LOAD DATAINFILE '/.../terminal.dat'INTO TABLE TERMINALFIELDS TERMINATED BY ','(TERMINAL_POSITION_ID ,TERMINAL_POSITION_NAME ,TERMINAL_POSITION_DESCRIPTION) terminal.sh sqlldr username/password control =/.../terminal.ctl errors=50 bad =/./terminal.bad log =/../terminal.log Natalia L. Laracca - Original Message - 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 file:LOAD DATAINFILE = 'Disk05/terminal.dat'INTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY ',' ENCLOSED BY '"'(TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY "," ENCLOSED BY '"',TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY "," ENCLOSED BY '"',TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY ","ENCLOSED BY '"')terminal.dat file:A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package.B,Bottom,Terminals extend from the bottom of the package.D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows.for any reason, when entering sqlldr username/password control = /Disk05/terminal.ctl log =/Di! ! sk05/terminal.log data =" '/Disk05/terminal.dat'an error message shows:segmentation fault.Alternatively, when issuing sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data =" '/Disk05/terminal.dat'an error m! ! essage shows:lf iopn failed for file (terminal.log)Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated.ThanksTrang-Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTax Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTax Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax
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.datINTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY , ENCLOSED BY (TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY , ENCLOSED BY ,TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY , ENCLOSED BY ,TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY ,ENCLOSED BY )terminal.dat file:A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package.B,Bottom,Terminals extend from the bottom of the package.D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows.for any reason, when entering sqlldr username/password control = /Disk05/terminal.ctl log =/Di! sk05/terminal.log data =" '/Disk05/terminal.dat'an error message shows:segmentation fault.Alternatively, when issuing sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data =" '/Disk05/terminal.dat'an error message shows:lf iopn failed for file (terminal.log)Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated.ThanksTrang-Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTaxDo You Yahoo!? Yahoo! Tax Center - online filing with TurboTax
