Timeline for Is it possible to backup a subset of a database in Microsoft SQL Server?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 13, 2018 at 5:30 | comment | added | John K. N. |
I'd just like to point out that the script you are mentioning in your question is in fact the contents of a so-called .par file which contains the configuration for either a impdp or expdp in Oracle. You would store that script for example in a export.par file and then execute the command expdp parfile=export.par and if your Oracle has an export directory configured, you will be rewarded with an XX.dmp file containing the contents of an Oracle schema named XXXXX.
|
|
| Jun 13, 2018 at 0:59 | history | edited | MDCCL | CC BY-SA 4.0 |
Terminology.
|
| Jun 12, 2018 at 18:32 | comment | added | peterh | @mustaccio Sorry I might have been also my mistake. I don't know the Oracle terminology so well, however I think the OP wants a dump with the goal of backing his db up. :-) | |
| Jun 12, 2018 at 18:02 | answer | added | RDFozz | timeline score: 6 | |
| Jun 12, 2018 at 17:43 | comment | added | mustaccio | Oracle dump != backup. | |
| S Jun 12, 2018 at 17:41 | history | edited | RDFozz | CC BY-SA 4.0 |
Removing "schema" from title, as it's misleading; additional grammar tweaks.
|
| S Jun 12, 2018 at 17:41 | history | suggested | peterh | CC BY-SA 4.0 |
title, english++
|
| Jun 12, 2018 at 17:31 | review | Suggested edits | |||
| S Jun 12, 2018 at 17:41 | |||||
| Jun 12, 2018 at 17:27 | review | First posts | |||
| Jun 12, 2018 at 17:31 | |||||
| Jun 12, 2018 at 17:26 | comment | added | Aaron Bertrand | I wouldn't use a backup for this, I would automate using a schema / data compare product, there are plenty out there but we have one you can look at. | |
| Jun 12, 2018 at 17:23 | history | asked | Sai Kishan | CC BY-SA 4.0 |