Re: Is there an sql command that I could run on a users schema to generate the sql code for the creation of those objects?
From: Scott Kerr <scott.alba_at_verizon.net>
Date: Tue, 06 Feb 2001 18:46:57 GMT
Message-ID: <BEXf6.7914$Nx3.2107930_at_typhoon2.ba-dsg.net>
Date: Tue, 06 Feb 2001 18:46:57 GMT
Message-ID: <BEXf6.7914$Nx3.2107930_at_typhoon2.ba-dsg.net>
Thanks for getting back to me. I have been using an object by object method
also, but it seems like there must be something available. When I use the
DBA studio and use the "Create Like" command, it see the sql code for the
creation of that object (minus the original objects name).
"Jason Burgoyne" <jason.burgoyne_at_bms.com> wrote in message
news:3A804420.C1E8E622_at_bms.com...
> To the best of my knowledge there is no way to do that, I have always used
> tools like ExpEditor or T.O.A.D. to do that. The draw back is I normally
have
> to do it one object at a time. Don't know if this helps at all, maybe
someone
> knows a better tool than those.
>
Received on Tue Feb 06 2001 - 19:46:57 CET