Hello community,
I have an 11.1.0.7 database with an 18TB schema called "APP" and over time users have created custom tables and indexes that I now need to move to a new schema, called "CUSTOM". The new schema would still exist in the same database and on the same storage, so I am looking for advice on how to accomplish this. I don't have a TB of free storage to do a datapump export and then import, so I was wondering if there is a real-time way to export and import the data that will not require a large amount of storage. I read that a database link would work for different hosts and DBs, but it doesn't sound like this would work on the same host and DB. Any input would be greatly appreciated.