Home » RDBMS Server » Server Utilities » Taking backup of your own Schema without DBA provs (12c (12.1.X))
Taking backup of your own Schema without DBA provs [message #684055] Mon, 29 March 2021 23:08 Go to next message
narenjoshi@yahoo.com
Messages: 1
Registered: March 2021
Junior Member
Hi All
I am using a schema to create contents for another tool's metadata. This tool uses encrypted tablespace to create some contents.

So my question is, "If I don't have DBA privileges but I know the password for my userid/schema, then how can I take backup which includes backup of encrypted tablespace as well ?"


I did try

exp USER1/PASS1@SVC_NAME file=/tmp/dumpfile.dmp log=/tmp/db.log owner='USER1'

It started the export, but gave error EXP-00111 Table XYX resides in an encrypted Tablespace XYZXYXZ and will not be exported.

Re: Taking backup of your own Schema without DBA provs [message #684056 is a reply to message #684055] Tue, 30 March 2021 00:31 Go to previous message
Michel Cadot
Messages: 67846
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

EXP-00111: Table %s resides in an Encrypted Tablespace %s and will not be exported
 *Cause: Encrypted Tablespace feature is not supported by classic export
 *Action: Use DATAPUMP Utility to export this table.
That is, use "expdp".

Previous Topic: impdp execution but not statistics in target schema
Goto Forum:
  


Current Time: Tue May 11 17:55:21 CDT 2021