This content has been marked as final. Show 2 replies
Are you saying that you want to generate a DDL script from a converted Oracle schema and run it on some other database instance?. Ofcourse you can do that and it will include work. If you have not changed anything in the Oracle schema after migrating from another database, then you can probably re-use the DDL script generated by SQLDeveloper for the first time. I hope this makes sense.
following thing i would like to do.
1)i want to generate the script using Tools->Database export wizard
2)i want to run it on same instance, but with diffrent schema.
3)the script u where talking about was generated by sqldevloper at first time at the time of migration or it was scipt generated by Tools->Database export wizard.
so basically i want to create more than one schema and run the same script of tables and sp on same instance and or diffrent instance on diffrent machine also.