Hi database Community,

I have following specification with me
1>New Database(9.2) at place A
2>Old Database(9.2) at place B

Now i want to transfer table data at Place A into flat file(.csv,.txt
etc.)

And again re read flat file data and put it into table at place B

In short i want write data into flat file and read data from flat file.


Could anyone tell me what is better way to achieve this.
I am Beginner (practice purpose) If possible give some link for
downloading the tutorial


Thanking in advance
Sanjeev N.A.

"sanjeev" <sanjeev_atvankar@yahoo.co.in> a écrit dans le message de news: 1162014097.876584.128470@f16g2000cwb.googlegroups. com...
| Hi database Community,
|
| I have following specification with me
| 1>New Database(9.2) at place A
| 2>Old Database(9.2) at place B
|
| Now i want to transfer table data at Place A into flat file(.csv,.txt
| etc.)
|
| And again re read flat file data and put it into table at place B
|
| In short i want write data into flat file and read data from flat file.
|
|
| Could anyone tell me what is better way to achieve this.
| I am Beginner (practice purpose) If possible give some link for
| downloading the tutorial
|
|
| Thanking in advance
| Sanjeev N.A.
|

Unloader:
http://asktom.oracle.com/~tkyte/flat/index.html

SQL*Loader:
http://download-uk.oracle.com/docs/c.../ch03.htm#1656

You can also use exp/imp:
http://download-uk.oracle.com/docs/c...rt1.htm#435787

Regards
Michel Cadot

sanjeev wrote:
> Hi database Community,
>
> I have following specification with me
> 1>New Database(9.2) at place A
> 2>Old Database(9.2) at place B
>
> Now i want to transfer table data at Place A into flat file(.csv,.txt
> etc.)
>
> And again re read flat file data and put it into table at place B
>
> In short i want write data into flat file and read data from flat file.
> and how to automate it.
>
> Could anyone tell me what is better way to achieve this.
> I am Beginner (practice purpose) If possible give some link for
> downloading the tutorial
>
>
> Thanking in advance
> Sanjeev N.A.