Re: starting Oracle in NT... [message #367948] |
Thu, 22 June 2000 07:14 |
Amber Fatima
Messages: 19 Registered: September 1999
|
Junior Member |
|
|
enter the following command:
SVRMGR30> connect internal/oracle
Connected.
SVRMGR30> startup pfile=c:\orant\database\initORCL.ora
ragards,
amber.
|
|
|
|
|
Re: import dbase/foxpro files with SQL*Loader [message #367990 is a reply to message #367989] |
Thu, 09 September 1999 02:14 |
Thomas Schaefer
Messages: 1 Registered: September 1999
|
Junior Member |
|
|
I found this in the net, but there was still no time to check, if it works. It would be nice to receive your report about the program.
thanx thomas
NAME
dbfx - extract data from dBase/Foxpro DBF files
RELEASE
bbfx - version 1.5
DESCRIPTION
Dbfx is designed to directly read uncompressed dBase/FoxPro DBF database files created on a PC. It was written in order to facilitate direct import into mainframe databases such as Oracle without requiring preprocessing on a PC. On the UNIX machine the DBF files must have been imported using binary mode transfer.
This software is distributed without any warranties express or implied. Use it at your own risk. See DISCLAIMER below.
AVAILABILITY
Dbfx is available by anonymous ftp:
host: aqueous.ml.csiro.au
IP: 192.67.12.100
dir: /pub/software/jstander/dbfx
Mirror or same machine
ftp://ftp.ml.csiro.au/software/jstander/dbfx
|
|
|
Re: import dbase/foxpro files with SQL*Loader [message #367994 is a reply to message #367948] |
Mon, 13 September 1999 10:02 |
abhi
Messages: 16 Registered: September 1999
|
Junior Member |
|
|
i think it's possible to export data from lotus approach directly to oracle tables..using odbc
though i hv not used it personally.
we hv been using text delimited files only with sql*loader and felt it was straight forward enough. u can generate a pipe separated or fixed lenggth file easily from approach.
|
|
|
|
|