Hi Earl, one suggestion for your suggestion... I often use SQLLoader to export and import...it's faster and more suitable for a large data amount. have a look...
10625
Contreras, Juan
JUContreras@...
Dec 1, 2001 5:02 pm
Hi people! Any suggestion for migrating dbf to oracle???? John...
10626
Matthias Kroll
kroll02
Dec 1, 2001 5:04 pm
Hi Anthony, do have oracle names server ? Try to add your remote DB to the tnsnames.ora with 8i net8 Assistent node Profile you should get connected after...
10627
Matthias Kroll
kroll02
Dec 1, 2001 5:12 pm
Hi John, http://www.oracle.com/forums/message.jsp?id=402042 dbase --> access --> SQLLoader Matthias...
10628
Contreras, Juan
JUContreras@...
Dec 1, 2001 5:14 pm
What about "memo" type?...
10629
bob sullivan
beaglezz
Dec 1, 2001 5:31 pm
... I'm assuming you mean dBase .dbf files... There's probably a tool out there that will do allow you to do this sort of thing more easily, but here's how I'd...
10630
Matthias Kroll
kroll02
Dec 1, 2001 5:32 pm
..check the contents if you have data larger than 4000 Byte you need to use CLOB columns (no direct load possible --slows down) in everey other case you can go...
10631
Earl Wertheimer
ewertheimer@...
Dec 1, 2001 10:21 pm
Matthias ... I already use SQL*Loader to import large volumes of the same format.. but SQL*Loader will not create the table... correct?? Earl...
10632
Matthias Kroll
kroll02
Dec 2, 2001 12:52 am
Hi Earl, thats right, but if you often have to load brand new table so give oriole a try. If your goin to 9i sometimes you can do one sqlscript to create the ...
10633
João Prates
jmmp00
Dec 3, 2001 10:55 am
Hi all, I've been out of the office last week, so I would like to apologize if by any chance someone replied or asked me something in this group and had no ...
10634
BSullivan@...
Dec 3, 2001 8:35 pm
Can anyone tell me if the TOAD in anyway uses MDAC (Microsoft Data Access Control - I believe)? Thanks much, Bob Sullivan Genencor International, Inc....
10635
Colin Wright
colinderekwr...
Dec 3, 2001 8:51 pm
Nope. ... From: BSullivan@... [mailto:BSullivan@...] Sent: 03 December 2001 20:34 To: toad@yahoogroups.com Subject: [toad] MDAC Can anyone...
10636
Moody, Mark
moodymark@...
Dec 3, 2001 8:57 pm
I believe that Jim is still using the Direct Oracle Access component from AllRound Automations. Mark Moody Manager of Applications Programming Oracle DBA PRA...
10637
Kevin Angus
kangus2000
Dec 4, 2001 5:31 pm
Toadman, In the Object Search results when a package is double clicked on the package BODY text is loaded. I think the problem is in the following query: ...
10638
Chris Johnson
cjohnson@...
Dec 4, 2001 5:36 pm
Any idea why sometimes when I execute a stored procedure or package via the lightning bolt in the SB, it will run the procedure successfully to completion, but...
10639
David_McMaster@...
Dec 4, 2001 8:11 pm
Careful out there guys & gals, I've already gotten about 50 of these e-mails. David http://www.mcafee.com/anti-virus/viruses/Goner/default.asp?...
10640
Kevin Angus
kangus2000
Dec 5, 2001 8:17 am
Don't know what happened there - when I got the message back from the group it was blank! I'll try again......
10641
Bryan Bell
bryanbelluk
Dec 5, 2001 10:49 am
Hi all, A general question. My client has a large user base and we are looking into the pros and cons of installing TOAD as a PC only or a client / server...
10642
Mauro Papandrea
mauro.papandrea@...
Dec 6, 2001 7:52 am
I am using the beta 7.1.11.29. When using the button to create a script for a tablespace, if it is a locally managed one the generated script contains the...
10643
Jesper Nyholm
Jesper.Nyholm@...
Dec 6, 2001 8:09 am
Hi Is it possible to import data from Microsoft Excel to Oracle via TOAD? Thanks Jesper ______________________________________________ The recipient...
10644
Ian Turnbull
pvfc_2000
Dec 6, 2001 8:13 am
Yes, save your spread sheet as a CSV file. Define a table with the same number of columns and data types. Uses SQL*Loader to load in you data. You don't really...
10645
offset00
Dec 6, 2001 8:34 am
10646
offset00
Dec 6, 2001 8:44 am
This one could do some damage to databases, that use the date formating option 'dd.mm.yyyy', e.g. german ones. When choosing this option and updating a date...
10647
offset00
Dec 6, 2001 8:58 am
... I would make a M$ACCESS table from the spreadsheet and then export this table to ORACLE (external database...) via the Oracle ODBC driver. (Download it...
10648
Baldvin Baldvinsson
baldvin@...
Dec 6, 2001 10:12 am
Anyone know when to expect new commercial version of Toad? Jim? Dave? Regards, Baldvin....
10649
Erwan DUROSELLE
EDuroselle@...
Dec 6, 2001 10:23 am
Next commercial version is expected on December 15 Toadman said the 7.2 release will extend the DBA module through June 30, 2002. -- Erwan DUROSELLE --...
10650
Tan, Zheng
ZTan@...
Dec 6, 2001 3:08 pm
Hi All, I understand that Toad does not have Backup and recovery functions. Is that correct? Please advice. Thanks. ... From: Erwan DUROSELLE...
10651
toadman
toadman@...
Dec 6, 2001 8:19 pm
All of the fixes listed from the past week (mostly the past few days) More fixes and polish on the PE That New Connection, end connection, New connection AV...
10652
Norman Dunbar
normandunbar
Dec 7, 2001 9:10 am
I remember Toadman opening an accout to raise some money for the orphange from us lot via PayPal. I found this on a C++ Newsgroup this morning and wonder if it...
10653
MIQUEL Bernard - FON ...
Bernard.MIQUEL@...
Dec 7, 2001 12:49 pm
Hello, I need to know exactly the use that i can made in my Office of toad freeware. Is it possible to use toad freeware at a big scale in a company or shall ...
