You should not get stuck in the Cloud. There are various options to create Oracle Cloud backup, but is very important to keep a local copy of your data. One of the simplest options to create a local copy of data from the Oracle Cloud - use Oracle SQL Developer.
Define Oracle Cloud DB connection in SQL Developer (the same as regular DB connection):
Use Database Export utility from Oracle SQL Developer:
Allows to export schema DDL, together with data (various formats, SQL INSERT statements one of them):
You can choose from long list of DB objects to export, this includes indexes, triggers, constraints, tables, etc.:
In my use case I select all objects to export (except PS_TXN):
There is option to filter exported data, again I will export all data:
Schema structure along with data is exported successfully:
Define Oracle Cloud DB connection in SQL Developer (the same as regular DB connection):
Use Database Export utility from Oracle SQL Developer:
Allows to export schema DDL, together with data (various formats, SQL INSERT statements one of them):
You can choose from long list of DB objects to export, this includes indexes, triggers, constraints, tables, etc.:
In my use case I select all objects to export (except PS_TXN):
There is option to filter exported data, again I will export all data:
Schema structure along with data is exported successfully:
No comments:
Post a Comment