Flatfiles from oracle tables
Date: Mon, 8 Mar 1993 21:49:44 GMT
Message-ID: <C3LBAy.A4v_at_news.iastate.edu>
This bounced from mail so am posting.
In article <1993Mar5.211729.12302_at_newsgate.sps.mot.com>,
beutel_at_chdasic.sps.mot.com (Jim Beutel) writes:
>
>Help is an understatement. We currently have a need to dump
>the entire database for input into another application. New
>project is DDTS on the workstation. Needless to say Export /
>Import will not work. Currently executing daily full export.
>Total dumped file is only 17000 blocks. Not very big really.
>
>Our Oracle DBA has recently and untimely taken a medical leave.
>
>My question is basically:
> Can the exported file be converted into a usable flat ascii file
> somehow..? Maybe using the dcl convert command.
>
>Dont know enough SQL plus to write a script in short order. Anyone
>else out there ever have a need to dump the data base?
>
>Thanks in advance
>-------------------------------------------------------
>Jim Beutel
>
>Motorola SPS ASIC beutel_at_chdasic.sps.mot.com
>1300 N. Alma School Rd Computer Operations
>M/S CH290 AZ50 office: (602) 821-4967
>Chandler, Arizona 85224 telefax: (602) 821-4963
>-------------------------------------------------------
You cannot convert the exported files as they are a bunch of insert
statements. You will have to go into SQL*Plus and generate a flat
file with the spool command and a select statement:
(this is from an earlier posting; I modified it slightly):
spool name1
select '"',col1,'"',',','"',col2,'"',',','"',col3,'"' from ... etc.;
spool off
This generates a comma delimited file with double quoted strings
Hope this helps. Good luck.
Marvin Beck Iowa State University
15:32:11 03/08/93 FROM Mailer-Daemon_at_motsps.sps.mot.com "Mail Delivery Subsystem": Returned mail: Unable to deliver mail
Received: by ISUMVS.IASTATE.EDU; Mon, 8 Mar 93 15:32:11 CST
Received: from spsgate.sps.mot.com by relay1.UU.NET with SMTP
(5.61/UUNET-internet-primary) id AA05594; Mon, 8 Mar 93 16:30:23 -0500 Received: by spsgate.sps.mot.com (4.1/SMI-4.1)
id AA12512; Mon, 8 Mar 93 14:30:24 MST Message-Id: <9303082130.AA12512_at_spsgate.sps.mot.com> Received: from uunet!ISUMVS.IASTATE.EDU by motsps (4.1/SMI-4.0/Email 1.1)
id AC02661; Mon, 8 Mar 93 14:27:32 MST
Date: Mon, 8 Mar 93 14:27:32 MST
From: Mailer-Daemon_at_motsps.sps.mot.com (Mail Delivery Subsystem)
Subject: Returned mail: Unable to deliver mail
To: uunet!ISUMVS.IASTATE.EDU!GO.MSB_at_uunet.UU.NET
- Transcript of session follows ----- 554 beutel_at_chdasis.sps.mot.com... Never heard of chdasis in domain sps . mot . com 554 uunet!ISUMVS.IASTATE.EDU!GO.MSB... Possible alias loop 554 No valid recipients
- Unsent message follows ----- Received: from uunet!ISUMVS.IASTATE.EDU by motsps (4.1/SMI-4.0/Email 1.1) id AA02661; Mon, 8 Mar 93 14:27:32 MST From: ISUMVS.IASTATE.EDU!GO.MSB_at_uunet.uucp Received: from uunet.UUCP by spsgate.sps.mot.com (4.1/SMI-4.1) id AA11962; Mon, 8 Mar 93 14:24:40 MST Received: from ISUMVS.IASTATE.EDU by relay1.UU.NET with SMTP (5.61/UUNET-internet-primary) id AA01977; Mon, 8 Mar 93 16:18:25 -0500 Message-Id: <9303082118.AA01977_at_relay1.UU.NET> Date: Mon, 8 Mar 93 15:19:13 CST To: beutel_at_chdasis
In article <1993Mar5.211729.12302_at_newsgate.sps.mot.com>,
beutel_at_chdasic.sps.mot.com (Jim Beutel) writes:
>
>Help is an understatement. We currently have a need to dump
>the entire database for input into another application. New
>project is DDTS on the workstation. Needless to say Export /
>Import will not work. Currently executing daily full export.
>Total dumped file is only 17000 blocks. Not very big really.
>
>Our Oracle DBA has recently and untimely taken a medical leave.
>
>My question is basically:
> Can the exported file be converted into a usable flat ascii file
> somehow..? Maybe using the dcl convert command.
>
>Dont know enough SQL plus to write a script in short order. Anyone
>else out there ever have a need to dump the data base?
>
>Thanks in advance
>-------------------------------------------------------
>Jim Beutel
>
>Motorola SPS ASIC beutel_at_chdasic.sps.mot.com
>1300 N. Alma School Rd Computer Operations
>M/S CH290 AZ50 office: (602) 821-4967
>Chandler, Arizona 85224 telefax: (602) 821-4963
>-------------------------------------------------------
You cannot convert the exported files as they are a bunch of insert
statements. You will have to go into SQL*Plus and generate a flat
file with the spool command and a select statement:
(this is from an earlier posting; I modified it slightly):
spool name1
select '"',col1,'"',',','"',col2,'"',',','"',col3,'"' from ... etc.;
spool off
This generates a comma delimited file with double quoted strings
Hope this helps. Good luck.
Marvin Beck Iowa State University Received on Mon Mar 08 1993 - 22:49:44 CET