Copy table attributes

I am using oracle 7.0.15.4 in a application. I previously used empress database. In empress we gave the command "empsqlcmd database_name dump tmp_file" on the command line and it would create a file that showed the columns of the table, we could then issue the command "empsqlcmd database_name create new_table_name from tmp_file". These commands in a shell script called from a larger application would create a new table that has all the same columns and constraints as the old table.

In Oracle the import/export functions would create a table with the same name, or in this case bomb because I am trying to overwrite the old table. Does anyone have any suggestions.

Thanks in advance.

Mike

msbaer_at_cast.msstate.edu Received on Thu Jul 14 1994 - 21:59:30 CEST