Is there a simple way to create a new table with the same structure as a given one in a *different* database? That means the CREATE TABLE foo AS SELECT * FROM bar WHERE 1=2 method won't work. Didn't find anything in some searching. I'd need to have two database handles open. They're both Oracle, but there's no chance of a cross-database link here.
-- Peter Scott http://www.perlmedic.com/ http://www.perldebugged.com/
