-
Sep 19th, 2014, 11:19 AM
#1
Thread Starter
PowerPoster
[RESOLVED] .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net
i am from MySql + vb.net back ground
my task is to take the query output from the DB2 9.7 and create the .dbf file for ORACLE 10g
in this connection i need some advises
what exactly is this .Dbf file is , is this just like a .sql file
is there any way to create the .Dbf file from DB2 database using ado.net
-
Sep 23rd, 2014, 09:57 AM
#2
Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net
.dbf is the extension of the file that oracle uses to store its data.
Database datafiles are physical files stored on disk. These files are used to store data on disk. You cannot directly write to these files.
That is what RDBMS systems were invented for. You can use a tool like sqlplus or TOAD or your client program to login to the oracle database and then update the data that is held in these files.
.dbf also incidentally happens to be the same extension used by the dBaseIII systems. These files are different from the oracle datafiles I mentioned earlier.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Sep 27th, 2014, 08:09 AM
#3
Thread Starter
PowerPoster
Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net
thanks abhi for reply
is it possible to execute the .sql files with in oracle , i mean the file with series of INSERT statements to an existing table of oracle
-
Sep 29th, 2014, 07:34 AM
#4
Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net
Originally Posted by make me rain
thanks abhi for reply
is it possible to execute the .sql files with in oracle , i mean the file with series of INSERT statements to an existing table of oracle
The short answer is YES. You would execute it at the SQL PLUS prompt after logging into the database server.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Oct 9th, 2014, 07:59 AM
#5
Thread Starter
PowerPoster
Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net
Thanks abhijit ji
it worked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|