Newsgroups: comp.databases.oracle
Distribution: world
Followup-To: 
<1992Sep4.090637.346@hhcs.gov.au>
From: aaj@cmutual.com.au (Tony Jambu)
Organization: Colonial Mutual Life Australia 
Subject: how to compress database and move indexes to different t

In article <1992Sep4.090637.346@hhcs.gov.au>, pihlab@hhcs.gov.au
writes:
> > However, how to I move the corrisponding indexes? I have tried using the
> > "show" option of IMP to generate a file, but this file is in such a poor
> > format I cannot use it without EXTENSIVE editing. Does anybody have a
> > utility that will take the file generated by the "show" option and make it
> > usable? The format I get is ONLY 80 column records and EVERY line is
> > enclosed in double quotes.
> 
> I don't have any formatter for you.
> 
> There is an INDEXES=file (can't remember the exact name) parameter for IMPORT
> which pulls out the TABLE and INDEX definitions to a flat file automatically.
> It is mentioned in the V5 to V6 upgrade documentation because you had to
check
> that INDEX names were unique across all objects for each user.  If you can
get
> that working then you need only add the TABLESPACE component.
> 
> You but you might consider creating a script of CREATE INDEX statements
> directly from the INDEX definitions in the database.
> 


The exact syntax is
	imp user/password INDEXFILE=FILE file=...

Problem with this approach is that it does not include a number of objects.
For example views.

Now, I have this utility that was written by a colllegue and is called 'impl2sql'.
It is very useful as it formats the output from imp's SHOW in a very useable
format.  To use it, 

1. Cut starting from the 'begin' line to the 'end' line into a file, FILE
2. Decode it useing 'uudecode FILE'
3. uncompress impl2sql.Z

To use it have a read of the description in the head of the file.


--------------------------------- ATTACHMENT ---------------------------------
begin 777 impl2sql.Z
M'YV0(T*\$)/&S8LY:!2,4 C"29 F11@F2-,&#AL9<^*P =$"!! 4(U(,>>/&
M3ADY=.: >"(GS!@V94!0A/,&)0@4;MZ D//FSIP4(-BDF4,'!!V=4Z(P 3%G
MC)PT<.@PG)+%R1,H4Y),80BBJU>$.F16!/%B9\\Y/=R ,),&9H\R>."0"4/'
M!9FQ"'OVR -"A@\3,4#P$6L1HT80/@@+)>HB(QNN7KN. 4N8:1ZB9=J\:!/&
M39@S)\WZ3,L4C5Z^;-W"E4O7[E@^)D H3#"QXD7'B!4/K>N8(9$B4X9(20*%
M2I(G3B!'-I)&#E$0;\R ",.&#0L03LO0C1DFZ)LS:]O&-,.SC5$T,=_4H0-G
M/73I+%W"E&C#!0P7,V 0KEET?=LT=.3A0E=5S!$3'6C0-9U*",8TDWMFU'3>
M4$PY!954(X"0P!UHI#$&&B#<T=9&=SQ%!W=,U0%@&&+ !$)23*@ !1MUJ-34
M4U$9I1-19*A7ET(24=&A2OX)%:!,*L$1!DH>UL'&DFSP56,99C@9(GIJ-0C"
M:OR%YZ(<5)XTAT1'@2!"A&"F<88;(AC%(DQS*#E&&2IU1@8(G/&5H$D@U'%&
ME"# @<9E'E+'U%$M@2:1DBVU4<:)SIVG8)X@B''@&SH1!!Z:(.2AGAR68=;&
M@"!0H1-H16DY%QUA2%10F=W-P5EUH<UQV8EM7,>6<T7)48=:\;WD8$5=%@D@
M7R(B2"9Z9O(TFEIYW;%7FV]$E09)=;IQ)QTMP7%>>NNUEZI.W=U1TQH%G2%1
M:F60*L6O$ZK$[GD\^0GB3+<=5B8</)%1QYS?,J61135*=..%TVF[)1D !@SF
M'$Z.FV+#GM8!*JLMTBDGG0F3L>B@<Q2Z$5$U?183&70V1Z<+$DET!9;Q@I"@
M2I:6H5:/;I1QG9T!XW9PCKZZH=(32]"KWAD)99B JG2Q&(:!UU6,76??WJR3
MEC-U&5W +M%1AZ'.SL'"HF":<=*;R ((H@AJY@3F7MB]T48; $X+G;78,O4H
MJ4*>W+3!ICEY9TYW5.J@6A6#NJK3!H:H=J>?!EKV26#>27*B92RZ9!B.0CH'
MRQE:105P( 3A!!$@7!&$%$XDX<016RG==WB\!KID45MK^7.O98SQG1M#<1QG
M[VD82M13;IS!8((8:IAS&=MF.EY;D$(/G7L2:HFF>;JS:M/6W<%XZ':.NO&C
M[,P*E;-*),GDAKC3@5EUI3RM87.?WBJX!N%JB3!'&&9K$TU>];D@,<M OE,8
MHW G'=U9*$=J>$-!5*(^CG'H) <Z(*MP9;/F;>AI#7D"%>CW!ONI14&Q F!,
M!FB^CH&@1QSK#D$8*+E'!2A=^ .=<KSRA)Q-*'D@2(+,PL G?&6F@]9+X)SD
MD+,[?:@SH&&03J84J61U*$OHD8B_QL(NO@TI1""48</ 9[N"7&<..A$B_ HR
M'1 , 3E.*,(01FBP#1ZQA?SJ'?2L)P:^=$<*16@"1UK0D2$@P71'* ((JC"%
M(DAAD!VIH/L"YJ@Y_ \TH-.0D"B4%\$9;F$ LA[/M$3%$R3I:7,PEQSNM$8W
MD.H)#9*#B* FD3&XIP[>TIYX*J4GGO$,50&CHHYV J\&F<= C-I.E'2HM)$(
MC5MA(. 0^923HN3A48:[WXDP0P9F=B4!(YE;!U5B1?JYQ'XIF:0Q'5>=3_I)
M*&R!GC<3X 2=<,8-7]N(DD#3*6QVA"@CF@X;!!6&>5I!3-<2VGM6TA)A[>=[
ML904%A7$L..E00SKL9X5)6*'^MPG/_BY215:AP6@["DFHLMFENATHFYV99,J
MF5RDRM0@B<"E=^MYD\Y".$(M<<DF\P*0@=A@ADP&H0I40,(3I" 1(A Q#7>B
MPH"$0!<0)2 &.<A!#!C2A#<P+)YWTL%L3.4&OBB!<Q@%4H:\TH*8G. %7G"!
M7.=*U[K:]:YXS:M>]\I7%Y#@!2'8PPDXXM8YO$ $?]W!"P;;5A"<H ^#Y8("
M#'2GQK[5"UL(0@NT$(86Z*$++R!#9!40&<L:U@M<&%#6F 1$87(!!5OP @BZ
M$-O9JH +0%'!7P$I2$(6\I"O4R0C'0E)R;[1"7&<(PBX$ /%CK:T;GU!:I<[
MH#F@"PYP2%=HG\O6Z'KAKZ)=+FF[ZUBX]O6\Z$VO>NGZU\ RMK"'3>QB">M8
MR(H7NHX];5=$\-HC2,%T(SQN<JF VQ?L0++,G:]D\6M*N.ZWO_]UP@@!.84G
M5$$*0RA"@0^L@ 1SMRNF=;"9( S@()ZN"%C8,()CH.#Q@AB^LATQ"OQ;XM\P
MH0BC4W&'6?QA^C8XQOR=<81'& 0FC$X*.O;P?<G[XP<+N<15@ (1@I#C%!AX
MQ2UFL'YE3&,)OZ@(-YYCDGF\Y!?G5\1![O((7==(*1#8RAQ6\H*9O.4T#QD$
M1!!"$,:<93JC^;7"*0*5%2F%)S"!"7H>PA+XW.,0 QG0@!QTJ8(@A!LSNLP^
MKC.D!3VZ%U4%.5EHPJ7G;.8FRSC0DH9"%2J=A"&,VL69_C,*4-WI1D:A"D5P
M0H9?K659TUJXK;NUAN&,Y4;#V,F_-O%O4DSL'?>YU)J>=:1K_6DGA)K7?GZT
MM#FM2"LDH0A7P#:T95WD(T^ZTL"!0A!VW6PYP]K13BXW<8>+Y':3F=2QUO8;
MFP 1+R-GN?9^=JQO4A;)HN %9S#VF:_SVMC"H 4YZ$*!&>[LA&,ZQ"FP<@HD
M:V6+XSO$(+"R>#L^V,%(EK(^CN\+!.MC)[SWS/Q5BYE>,-\0QURQSO6Q?3\>
M7<2N_.4G<'FL8[Y?F@/=L#<W<,W=NO-W]_RO++>LT&W.!9F+P.A#KSK.EUY?
MA3?X.E>G^-4][O0S9_P%&U< R2\.7Z"   IS- (@BX#VKD@6[E20>Q'H3O9>
MOX@*2PU"(@\NWBD _K^)%._!^^YGH%"!TC>>@KHS7'?)/A[=DE\WW[U^6A2\
)U@4%]KRS!ZL 
 
end


-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au