Move Tables from One Schema to Another

This is just an example of moving few tables like 1 or 10, for more tables it might be a time consuming process. Here i am considering moving 1 table from one schema to another schema. Firstly create the DDL from 1 schema using this link:¬†https://getsomeoracle.wordpress.com/2013/11/07/export-oracle-ddl-to-flat-file-using-sql-developer and then simply change the Schema 2 in theContinue reading “Move Tables from One Schema to Another”

Export Oracle DDL to flat file using sql developer

Open SQL Developer, connect to the database. Below i connected to SYS user and then go to Other User in left pane. Here i am going to take the DDL of EMP table from SCOTT Schema Expand it and select the table for which you are looking for DDL.. Right click on the table. ClickContinue reading “Export Oracle DDL to flat file using sql developer”