From daemon Wed Dec 27 12:11:01 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA04817; Wed, 27 Dec 1995 12:10:55 -0500 Message-Id: <9512271710.AA04817@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 1600; Wed, 27 Dec 95 12:06:30 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 0241; Wed, 27 Dec 1995 12:06:25 -0500 Date: Wed, 27 Dec 1995 11:05:15 -0600 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Helena Whitaker Subject: Re: Exporting Directly to Tape X-To: "ORACLE database mailing list." X-Cc: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L On Wed, 27 Dec 1995, Kilner, Carol wrote: > Has any one had any experience doing an export directly to dat tape on an > HP-UX version 10. > > I specify the tape drive as the export location i.e. /dev/rmt/0mbd and > export a few tables. Everything seems to work okay. > I then re-wind the tape and copy the backup onto disk and try to do an > import. > > I use: dd if = /dev/rmt/0mb of=exported.data > I then run imp and use this as the import file. I promptly get an error > . importing CTSSYS's objects into CTSSYS > IMP-00032: SQL statement exceeded buffer length > IMP-00009: abnormal end of export file > Import terminated successfully with warnings. > $ > I tried increasing the size of the buffer but this didn't seem to work. The > message also indicates it might be because the import file is corrupted. > > > Can anyone shed some light onto this issue? > I'm not on HP-UX 10 yet, but when I export to tape under HP-UX 9.0.4, I always import directly from tape. Are you sure dd can copy an export file properly from tape to disk ? (I once had a problem where one version of frecover improperly handled copying an fbackup file written under another version ... copy seemed ok but Oracle couldn't read the database file ... so I wouldn't be sure that dd can copy a file that oracle wrote directly to tape). My gut feeling is that export/import directly to/from tape will be consistent, export/import to/from disk with a dd to tape as a backup will be consistent, but export to tape, dd to disk, import from disk may not be. helena -- <:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:> <: Helena Whitaker, DBA helena@creighton.edu :> <: Creighton University (0800-1630 CT) (402)280-2311 :> <: Computer Center fax (402)280-2573 :> <: 2500 California Plaza Platform: HP-UX 9.0.4 (unix) :> <: Omaha, NE 68178-0046 HP 9000/H50, /E25, /842 :> <: (also Nebraska Oracle 7.1.6.2/SCT Banner Finance 2.0.3 :> <: Oracle Users Group) Oracle 7.1.6.2/DeLair Patient Accounting :> <:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>