Export from database 1 Import into database 2 Truncate table in database 2
-----Original Message----- From: Peter Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 2:38 PM To: dbi-users@perl.org Subject: Duplicate table structure 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/
