Hi all,
can U anybody help me? I'd like to export to the text file several table definitions from the database. Where can I find structure of any table in the database?
Thanx, Jami
Printable View
Hi all,
can U anybody help me? I'd like to export to the text file several table definitions from the database. Where can I find structure of any table in the database?
Thanx, Jami
export the tables you want:
exp tables=xxx,yyyy data=n userid=xxx/xxx file=xxx.dmp
Then imp with the show=y and log options. Buried in the resulting log file will be the create table commands.