Re: PLSQL for ddl

Dave why not run the exp command, stripped out the ddl(dont use strings on solaris its braindead after 1024 bytes, its just truncates).

someday i'll get mine done to do just that.

joe
David Turner wrote:
>
> I am writing several different procedures in plsql to help me drop and recreate
> all the constraints, foreign keys, indexes, grants, privileges associated with a given
> table so I can automate many of the mundane tasks I would like to avoid. Has anyone else
> done this and is willing to send me the code or list an html page where I can get them?
>
> Also has anyone done this in sqlj and is it even possible? I have hesitated working with sqlj
> because I thought much of the ddl I perform can only be done with plsql.
>
> Thanks, Dave Turner
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
> INET: turner_at_elvis.mu.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.