How can I generate Create table statements from Oracle Database in case I want copy some table in another database where Baan is not installed.

Thanks in advance.

Jay

Jay,

You could use the IMP/EXP utilities to copy a single or more tables.

I want to create the tables in SQLServer database without data. I am writing Baan Exchange Export and SqlServer DTS for regular transafer of data to be used for our web serve.

Thanks

You can use EXP with ROWS=N, that will avoid the export of data rows.

You use what Patrick mentions, becuase this will get you the create statements for each table, you then have to "edit" this export to make it work properly on SQLserver (and remove extra sql statements not needed).

Though there are different ways to generate a 'Create Table' statement in Oracle, the best thing would be to use exp/imp utilities. The procedure is as follows:
1. export ORACLE_SID=xxx (unix) or set ORACLE_SID=xxx (NT/2000)

2.exp <username>/<pwd> file=xx.dat log=exp.log rows=n tables=txxxxxxxx
(Make sure you use username and password of Table owner)

3. Import the above file into an ASCII format as follows:
imp <username>/<pwd> file=xx.dat log=imp.log full=y indexfile=table.sql

The option indexfile will create an ASCII file with Create Table and Create Index statements. By default the Create Table statement will be Commented and Create Index statement is available to be executed. Edit this 'table.sql' file and remove 'REM' infront of the 'Create Table' statement and edit the parameters etc and optionally keep the Create Index statements or delete them from the file and save it.

I wrote a awk script to manipulate the output file generated using EXP command.
I now have the create table statement I need.

One of my told of a website which has freeware, can be used to view the create table statement and can be cut and pasted. I have not used it yet but you all can try...
This is the link....
www.toadsoft.com

Why not defining new remote database to baan and then you can create it by Baan...

Like I said there are different ways to create the table. The procedure I have given has more flexibility to change the parameter of the table and location of the table etc, and is applicable to any situation and not necessarily with Baan.