Unanswered: Database Objects Replication in New Database
I have an Oracle 9i database on Windows 2000.
I created another database on the same Windows server. I want to replicate all the tables and stored procedures that I have in the existing database to the new database. Import does not help because the SID is different. Is there any way to duplicate all the tables and stored procedures in the new database from the old database without manually recreating them?