If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > import Dbase table into Oracle DBA Studios

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-22-03, 14:35
jeff3316 jeff3316 is offline
Registered User
 
Join Date: Jan 2003
Posts: 1
Exclamation import Dbase table into Oracle DBA Studios

How can I import Dbase tables into my Oracle DBA Studio?
Reply With Quote
  #2 (permalink)  
Old 01-24-03, 09:14
Wynne Wynne is offline
Registered User
 
Join Date: Jan 2003
Posts: 5
Please take a look at our ETL tool <http://www.etlsolutions.com> as this handles data exchange between databases and most data formats.
The approach would be to view the Dbase tables as a source and the Oracle database as a target and transform between them.
Our IDE is all Java technology and we deploy in Java as well.

regards

Wynne Rees (wr@etlsolutions.com)
Reply With Quote
  #3 (permalink)  
Old 01-27-03, 19:55
billm billm is offline
Drunkard
 
Join Date: Nov 2002
Location: Desk, slightly south of keyboard
Posts: 697
Re: import Dbase table into Oracle DBA Studios

Quote:
Originally posted by jeff3316
How can I import Dbase tables into my Oracle DBA Studio?
Hi,

I have some PL/SQL packages that can do direct table creation and/or imports of dbase tables server side. If your Dbase tables reside on the same host they can be imported at astounding speed.

You can also access them on other machines via a unc path.

They're based on work at Ask Tom @ oracle but with some additional file formats (dbt/fpt memos etc) added.

If they're of any interest let me know (here or pm me).

Regards
Bill
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On