in DB2 UDB, I have a database with name (sample), in this database, i have two schemas namely "sf", "sf123". in "sf" schema i have 10 tables. These tables i have to transfer to schema "sf123". I mean those 10 tables to be moved/copied to "sf123" schema.
These two schemas are available in same database (sample).
If any body have the idea. Please pass on your comments.