| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Informix to Oracle conversion
Hi,
Informix uses the UNIX login, the DBA (or DBSA as they call it, with the S for Server or System) account is "informix". To log in to isql or dbaccess, you need to have access rights granted by user "informix" to your login.
At the shop where I worked before, PowerDesigner (by Sybase) was used to reverse engineer an Oracle database and import it into Informix. All went fine, except for bitmapped indexes (Sybase does not have bitmap indexes in its Enterprise DB server - they do have "bitwise" indexes or so in their data warehouse DB server) which were created as ordinary indexes. So, I dropped those and recreated the bitmap indexes manually.
HTH,
Koen.
don%alldata.com_at_Internet
14/09/2000 04:31
To: ORACLE-L%fatcity.com_at_Internet cc: (bcc: Koen Lefever/GKBCCB) Subject: RE: Informix to Oracle conversion
I work with Informix. And not afraid to admit it. ;-) I'm just getting started with Oracle and haven't done any conversions yet but I see it pretty much a slam-dunk, excluding stored procedure and trigger rework of course.
You can use Informix's dbaccess, or isql if you have that. Either one is
sufficient enough to unload your data to files that Oracle can load from.
unload to "filename"
select * from tabname
will create a pipe delimited file. You can delimit with anything you want.
dbaccess is the equivalent to sqlplus, only much better in my opinion.
I gotta tell you guys, I feel like I'm selling my sole with a move to Oracle. That saying that you like what you know and hate everything else has it's truth. But I can say now that even after giving me a couple more years on Oracle, I'll still say that Informix is better than Oracle! Oracle has a couple of little things they do better, from what I've seen so far, but I think the only big thing they do better is Marketing! But hey, that's where the bucks are. I'm sold. ;-)
Don.
-----Original Message-----
Sent: Tuesday, September 12, 2000 3:45 PM
To: Multiple recipients of list ORACLE-L
Bill,
The help I need is not really with the kit but with just a few Informix basics. I have never worked with Informix and there is nolonger anyone here that has either(or won't admit to it anyway). The scripts supplied by the Oracle kit use dbadmin to interface with the database. I have no clue how to use this product and I'm running it against a production system. Do I need to logon as the Informix UNIX user and then run dbadmin? When I run it as annother user I get not connected errors, here is an example of the run
" dbaccess database_name script.sql"
Is there anything resembling sqlplus available for interacting with the database?
Thanks
...JIM... >>> wcarle_at_att.com 9/12/00 12:34:13 PM >>> I have done an Informix to Oracle conversion, but I'm not sure what the Oracle conversion kit is. I wrote my own conversion.
Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com
-----Original Message-----
Sent: Monday, September 11, 2000 4:51 PM To: Multiple recipients of list ORACLE-L Subject: Informix to Oracle conversion
DBA's
Has anyone done an Informix to Oracle conversion? I need a little help to get started with the Oracle conversion kit. Please contact me off list.
Thanks
Jim Howerton
jhowerton_at_uabmc.edu
-- Author: James Howerton INET: jhowerton_at_uabmc.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Sep 14 2000 - 03:25:54 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Carle, William T (Bill), NBSO INET: wcarle_at_att.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: James Howerton INET: jhowerton_at_uabmc.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Simpson, Don INET: don_at_alldata.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------------------------------ From: ddorr.cs_at_clearstream.com Date: Thu, 14 Sep 2000 10:28:46 +0200 Subject: RE: Collecting "Metrics" Use UTLBSTAT / UTLESTAT ( Oracle standard tools in $ORACLE_HOME/rdbms/admin ). There is also the DBMS_STATS package which can gather stats. Reading the Tuning manual from the Oracle documentation set ( books on CD ) will help you. > ---------- > From: Diana Duncan[SMTP:Diana_at_filefrenzy.com] > Reply To: ORACLE-L_at_fatcity.com > Sent: Wednesday, September 13, 2000 21:40 > To: Multiple recipients of list ORACLE-L > Subject: Collecting "Metrics" > > Listers, > > I've been asked to collect "metrics" on database performance. > Unfortunately, those asking can't give me a straight answer as to what > they > are looking for. Anyway, I haven't had to do this before other than for > specific tuning problems, so I thought I'd ask how anyone here goes about > it? Should I use TKPROF over a specific period of load testing? Or some > tool that can generate statistics? Or does anyone have any interesting > queries to extract stats from the v$ views? I think they would like > numbers > such as average response time of queries (which I have already managed to > provide somewhat through a test harness), percentage of cache hits, > numbers > of transactions processed in a time period, etc. > > Sorry for the general nature of the question, but I haven't been given > much > to go on myself... > > Diana Duncan > Database Architect > fileFrenzy.com > diana_at_filefrenzy.com > 919.833.1766 x 238 > > -- > Author: Diana Duncan > INET: Diana_at_fileFRENZY.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > ------------------------------ From: azhar_at_mathtech-pk.com Date: Thu, 14 Sep 2000 14:09:39 +0500 Subject: Re: Checking for empty date fields Andreas Jung <ajung_at_sz-sb. To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> de> cc: Sent by: Subject: Checking for empty date fields root_at_fatcity. com 09/14/2000 01:21 PM Please respond to ORACLE-L A very stupid question: I want to get all rows from user_indexes whose LAST_ANALYZED date column is empty (not analyzed yet). Neither "where last_analyzed=null" Try where last_analyzed is Null HTH Azhar nor "where to_char(last_analyzed)=''" did work. Any idea ? Thanks, Andreas -- Author: Andreas Jung INET: ajung_at_sz-sb.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------------------------------ From: Place for oracle <place4oracle_at_yahoo.com> Date: Thu, 14 Sep 2000 02:23:06 -0700 (PDT) Subject: Big Vldb ( Like Yahoo Mail) Hello, We will build a VLDB on Oracle/Sun. We will have more than one million user ( Web of course). Have someone any info how the dbs are on hotmail,yahoo ,spray,altavista,... I'm looking for some hints not the finish solution. Regards P.H ===== Place4oracle http://www.geocities.com/place4oracle/ __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ ------------------------------ From: ALEMU Abiy <abiy.alemu_at_criltechnology.com> Date: Thu, 14 Sep 2000 11:20:52 +0200 Subject: RE: passing variable from sqlplus to korn scripts .. What about in case you have more than one variables returned ? -----Message d'origine----- De: Som Priani [mailto:som.priani_at_myprice.com.au] Date: jeudi 14 septembre 2000 04:56 =C0: Multiple recipients of list ORACLE-L Objet: RE: passing variable from sqlplus to korn scripts .. varx=3D`sqlplus -s / <<EOF set head off feed off select value from v\$parameter where name =3D 'background_dump_dest' / exit EOF` echo $varx ............. Use $varx in the shell script HTH Som -----Original Message----- Sent: Thursday, September 14, 2000 9:02 AM To: Multiple recipients of list ORACLE-L Hi guys=20 goin thru a brain freeze here .. ur help appreciated in advance=20 here is the deal ... #!/bin/ksh # .. .. ksh code=20 .. ksh code=20 .. ksh code=20 .. $ORACLE_HOME/bin/sqlplus -s / <<__EOF1 declare bdump varchar2(1000); begin select value into bdump from v$parameter where name =3D'background_dump_dest'; end; / exit=20 __EOF1 ** how to accesss bdump variable value from sql*plas here in shell = script ??************** .. ksh code=20 .. ksh code=20 .. Thx deepAk --=20 Author: Thapliyal, Deepak INET: DThapliyal_at_ea.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). --=20 Author: Som Priani INET: som.priani_at_myprice.com.au Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------------------------------ From: "O'Neill, Sean" <Sean.ONeill_at_organon.ie> Date: Thu, 14 Sep 2000 11:34:00 +0200 Subject: RE: How many databases do you support? Hi Cherie, Interesting question!!! At the moment 3 Oracle DBs, 1 on VMS with Live, Test, Val instances, soon to migrate NT, 2 on NT. One of these with Live, Test and Val instances, other just Live. Other DB technology: 1 Supra DB on VMS with Live, Test, Val and "DBA Play" enviroments. 1 RMS DB on VMS with Live and Test environments. All of above are on separate servers and local. I'm the only DBA but there are support contracts in place too!. We have an NT Admin and a Sys Admin. The Supra DB is planned be replaced by an ERP type system DB technology?, hopefully Oracle (less extra learning) but apparently on NT platform. Expecting at least 3 new Oracle DBs on NT by end of year. I just do DBA stuff, no development apart from my own scripts to manage things!. I use Oracle8i PE to play and learn on a decidated PC so screwing it up don't matter ;) I think I will really need to take a look at OEM and some other goodies to automate some checks and e-mail alerts if the growth rate continues!. Sean :) ###### ###### ###### ###### # # # # # # # # Rookie #### # # ###### ###### Data # # # # # # # # Base # # ####### ###### # # Adminstrator -------------------------------- ------------ Organon (Ireland) Ltd. E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode] The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt ------------------------------ From: Cherie_Machler_at_gelco.com Date: Wed, 13 Sep 2000 12:28:58 -0500 Subject: How many databases do you support? Is there any sort of rule-of-thumb for how many database that a DBA should be expected to support? I realize that the answer would vary based on size of databases, stability, production vs. development, mission critical, 24/7, etc. But in general, how many databases would you think a DBA should be supporting if you divide the total number of databases in an organization by the number of DBAs supporting them? How many databases do you support on average? What is the size of your team? Trying to get ideas for the head count of our DBA team here and wondering what the industry standard is. Thanks Cherie ------------------------------ From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk> Date: Thu, 14 Sep 2000 14:28:41 +0500 Subject: RE: Enterprise manager. I guess from Listner.Ora -----Original Message----- From: Clinton Naude [mailto:clintonn_at_meb.co.za] Sent: Thursday, September 14, 2000 1:36 PM To: Multiple recipients of list ORACLE-L Subject: Enterprise manager. Hi all. I am battling with OEM, I am currently running the console on version 2.0.4 on a Windows 2000 pro box. The Oracle db is version 8.1.5 on a Solaris SunOS 5.8. The repository is also on the Sun box. I can connect 100% through sqlplus as well as onto the database from the console. I have even run a successful export from the console. However when trying to
 |
 |