RE: Data Retrieval Tool
Hello Dennis We bought PlSqlDeveloper. The tool show you a list of the tables. Right click on a table and you get a menu that let you (among other things) query and update the data. If I remember correctly it cost 750$ for 10 user license. Go to http://www.allroundautomations.com . Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Subject: Data Retrieval Tool Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of these databases have just a few tables in them I figure I can use sql loader to load the access tables into Oracle. But the tough part is, how do we have the users access the data once it is in Oracle? Since these are pretty static databases and we don't have the resources in house to develop front end tools to retrieve the data, I am wondering if there is a slick, user friendly tool out there can help us with this. Toad partially satisfies this need but I think it is an overkill for data access only. Also, it would be nice to have a web browser interface and some data insert and update capabilities without using sql. Alright I know now I am really push it... TIA Dennis Meng Database Administrator Focal Communications Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Data Retrieval Tool
One option is to look into Oracle's Migration Workbench. It's a free download from Technet (technet.oracle.com). It can take an existing Access datrabase, create the same tables in an Oracle schema, move the data to the Oracle tables, and so on. I've used it and it works well. One option it offers that I haven't used is to modify existing Access forms to use the new Oracle tables instead of the old Access database. I assume via ODBC. So in theory, your users could keep using their existing Access forms to update the Oracle data while you work on moving them to a different front end. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Data Retrieval Tool Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of these databases have just a few tables in them I figure I can use sql loader to load the access tables into Oracle. But the tough part is, how do we have the users access the data once it is in Oracle? Since these are pretty static databases and we don't have the resources in house to develop front end tools to retrieve the data, I am wondering if there is a slick, user friendly tool out there can help us with this. Toad partially satisfies this need but I think it is an overkill for data access only. Also, it would be nice to have a web browser interface and some data insert and update capabilities without using sql. Alright I know now I am really push it... TIA Dennis Meng Database Administrator Focal Communications Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Data Retrieval Tool
Dennis Move the tables into Oracle and let the users use Access via odbc ;-) [EMAIL PROTECTED] wrote: Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of these databases have just a few tables in them I figure I can use sql loader to load the access tables into Oracle. But the tough part is, how do we have the users access the data once it is in Oracle? Since these are pretty static databases and we don't have the resources in house to develop front end tools to retrieve the data, I am wondering if there is a slick, user friendly tool out there can help us with this. Toad partially satisfies this need but I think it is an overkill for data access only. Also, it would be nice to have a web browser interface and some data insert and update capabilities without using sql. Alright I know now I am really push it... TIA Dennis Meng Database Administrator Focal Communications Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Data Retrieval Tool
and to move the tables from access you could use the Migration workbench that you can get from OTN /torben holm Peter Gram wrote: Dennis Move the tables into Oracle and let the users use Access via odbc ;-) [EMAIL PROTECTED] wrote: Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of these databases have just a few tables in them I figure I can use sql loader to load the access tables into Oracle. But the tough part is, how do we have the users access the data once it is in Oracle? Since these are pretty static databases and we don't have the resources in house to develop front end tools to retrieve the data, I am wondering if there is a slick, user friendly tool out there can help us with this. Toad partially satisfies this need but I think it is an overkill for data access only. Also, it would be nice to have a web browser interface and some data insert and update capabilities without using sql. Alright I know now I am really push it... TIA Dennis Meng Database Administrator Focal Communications Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Torben Holm INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).