| Table of Contents |
|---|
...
| Code Block | ||
|---|---|---|
| ||
expdp <username>/<password>@<database-name> schemas=<username> DIRECTORY=DATA_PUMP_DIR DUMPFILE=<filename>.DMP flashback_time=systimestamp |
Example : expdp test/test@123@xe schemas=test_schema DIRECTORY=DATA_PUMP_DIR DUMPFILE=TEST-BACKUP-29-May-2019.DMPDMP flashback_time=systimestamp
User creation and permissions.
...
Note: Before running query run set long 10000 command.
SQL to retrieve the blob value in text format in Oracle.
Example : Extract the form XML stored in the dyextn_containers table.
| Code Block | ||
|---|---|---|
| ||
select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(XML, 2000,1)) form_xml from dyextn_containers where dbms_lob.instr (xml, utl_raw.cast_to_raw ('<form_name>'), 2000, 1) > 0; |
Note: At a time we can only retrieve 2000 bytes only, 2000 is no of bites to print and 1 is offset. If someone wants to print data after 2000th byte replace 1 with 2001 next 2000 bytes will get printed.