Search code examples
sqldatabaseoracleoracle11goracle-sqldeveloper

How to export databases seperatly in oracle 11G


In Sql-developer i have 3 different connection and 3 different databases , and i want to export them separately. Whenever i use expdp, it exports all of them together. I want to back up databases separately.


Solution

  • Looks like these are 3 different users (schemas) within the same database, not 3 different databases.

    Therefore, you should use schema mode in order to export each of them separately.