Re: Informix Unload equivalent in Oracle

Gregg Walker said: > >> If you must do this via an 'unload', look at import and export >> (imp/exp). >> You could perhaps export Partition X (from Table A), create a new >> partitioned table with the new partitions you want, import into this >> table, and then swap these partitions back into Table A. > > This sounds like a lot of tedious work since I have about 20 tables that > need to have this done. > >> Although I'm also not really sure why you are unloading the table at all >> ? > > Me either. It's my Informix mentality... :) Me neither, and I have an Informix mentality too. Haven't you heard of alter fragment? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list

> Me neither, and I have an Informix mentality too. Haven't you heard of > alter fragment? I don't use table fragments anymore for Informix. They take up too much of time to maintain for our particular applications. We currently use a RAID 10 configuration for the raw disk and put the db in one dbspace. This works quite well for us. So yes ... I've heard of alter fragment but because of my Oracle ignorance I wouldn't have equated an Oracle partition with an Informix table fragment. Then again maybe I need to be reeducated on Informix table fragments... :) "Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message news:1105701016.b2c61084f0b0620462657c4e055dc3ad@teranews... > > > Gregg Walker said: >> >>> If you must do this via an 'unload', look at import and export >>> (imp/exp). >>> You could perhaps export Partition X (from Table A), create a new >>> partitioned table with the new partitions you want, import into this >>> table, and then swap these partitions back into Table A. >> >> This sounds like a lot of tedious work since I have about 20 tables that >> need to have this done. >> >>> Although I'm also not really sure why you are unloading the table at all >>> ? >> >> Me either. It's my Informix mentality... :) > > Me neither, and I have an Informix mentality too. Haven't you heard of > alter fragment? > > -- > > Bye now, > Obnoxio > > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche > > "I'm trying to see things your way, but I can't get my head up my ass" > - JCH > > "Ogni uomo mi guarda come se fossi una testa di cazzo" > - Marco > > If anyone told you to be yourself they would be giving you bad advice. > > I went to the airport to check in and they asked what I did because I > looked like a terrorist. I said I was a comedian. They said, "Say > something funny then." I told them I had just graduated from flying > school. > > -- Ahmed Ahmed > sending to informix-list