One very simple way is to: OUTPUT filename UNLOAD STRUCTURE OUTPUT SCREEN
Now use a plain text editor which will handle the file size to hack out everything except the block of CREATE VIEW statements. I like UltraEdit for this stuff, although if your file is not too large, RBEdit will handle it. Dennis McGrath --- Bernard Lis <[EMAIL PROTECTED]> wrote: > How can I unload all the views in one database to insert into another > database (same name)? > > Bernie Lis > >
