I am new to toad and certainly db management if not my job. I am Java Developer, where I have a scenario to create tables in test environment which are exact copy of another environment from another db.
I have access to both tables with all permissions. All I need to do is, Get an exact copy of CREATE Table structure from Dev environment table to test environment.
Please guide me to do this.
Db: Oracle Toad Free ware 11.x
Note: Table data is not required. Needed only table columns and constraints etc.
Hit F4 after entering your table name -> Click on Script tab, you'll get the DDL statements.