Type: Posts; User: NamrataSV; Keyword(s):
This commands works for DB2...not sure about Oracle
U can also use this command: CREATE TABLE [TableName] LIKE [SourceTableName]