Re: exporting comments?

For lack of a better solution you could try the following but it needs to be done for each user:

on the server:
spool
select 'comment on column '||table_name||'.'||column_name||' is '''||comments||''';' from user_col_comments where comments is not null; select 'comment on table '||table_name||' is '''||comments||''';' from user_tab_comments where comments is not null; spool off

edit the output transfer it to the laptop and sun it with an _at_ command.

I'm sure there are more elegant ways to do it but it would take me longer to find one than it would take to do this

Also if you have comment on any table privilege you could hit all_col_comments and all_tab_comments and throw the username in as the schema to find the table in.

"Aparna" <bliss_is_ignorance_at_hotmail.com> wrote in message news:3ae6fb24.0_at_news.tm.net.my...
> hi all,
>
> by any chance is there a facility to export and import *only* column and
> table comments???
>
> i have 2 similar databases with different data... one on my server and one
> on my laptop... the DB on the server has column and table comments added
 to
> it while the one on my laptop does not have the same... i want to import
 the
> comments from the server DB to my laptop DB... can i do that??? any
> suggestions welcome...
>
> thanx for ur attention.
>
> regards,
> aparna
>
>
Received on Wed Apr 25 2001 - 18:57:44 CEST