Satya ---
Creating a table in Oracle is fairly easy (you have a database defined, right?) You can do it with SQL-PLUS, With SQL Passthrough in VFP, Oracle Designer 2000 .... etc. Once the table exists, create a Connection in a VFP database container through ODBC to the Oracle database. Then create a remote view, selecting the desired table.
>
>Initially I don't have data or not even tables in the ORACLE Server.
>First I have to CREATE A TABLE IN ORACLE SERVER.
>and then try to update from fox to Oracle and then the process of getting data from Oracle to Fox comes.
>and this continues.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05