How to take a data dump from a particular table which is a Oracle VDB. Does any utility available

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
How to take a data dump from a particular table which is a Oracle VDB. Does any utility available within Delphix. I am creating a table in the VDB. I wanted to take the dump of this table before doing Data Refresh/Data Rewind. Once the Data Refresh/Data Rewind is over. I wanted to bring back the data dump to the VDB. Please let me know your suggestions.
Photo of Ramesh

Ramesh

  • 518 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,422 Points 3k badge 2x thumb
Official Response
Hello,

An Oracle VDB is just an Oracle database. You could use your favorite technique that you normally use for Oracle such as its export utility:

https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

Thanks,
  Neal
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Ramesh, like Neal said, you can just use something like expdp/impdb (oracle datapump). Furthermore, you could configure these as pre-refresh and post-refresh hooks so that the table is exported and imported automatically as part of your refresh operation in Delphix.