How to export full schema without any constraint issues for one month date range

Question

I need to export the full schema of a one month data range. I have a lot of partitioned tables inside the schema, so I need a query to export a schema without any constraint issue or partitioned table issue.

Usually I use to take separate table mentioning all partitioned table names inside the query.

Please edit your question to include some more information. What you have tried so far? What exactly is your problem? What does your tables look like? You can have a look at [How to ask a good question?](https://stackoverflow.com/help/how-to-ask). — Björn Böing, Mar 19 '19 at 07:36

score 0 · Answer 1 · answered Mar 19 '19 at 07:13

0

I'm not sure you can do that (at least, not in a simple manner).

In order to export only part of every table, you'd have to use the QUERY parameter and include a WHERE clause to fetch data within the last month.

If there are many (actually, more than one or two) tables, I'd suggest you not to put everything into the command line, but to create a parameter file, put everything you use with EXPDP in there and use it later. It is easier to maintain.

answered Mar 19 '19 at 07:13

Littlefoot

131,892
15
35
57

I have lot of tables in a schema and how can we mention timestamp of one month of data for all mentioned tables , if some table has not a date column? – Geethanjali Ramaraj Mar 19 '19 at 07:25
Exactly. How? Can you tell us? Suppose you've given a task "select number of rows inserted during the last month". How would you do that? **Can** you do that? What tells you that those rows were inserted *yesterday* or *a week ago*, if there's no such a column? – Littlefoot Mar 19 '19 at 07:27
we can get from sysdate – Geethanjali Ramaraj Mar 19 '19 at 07:34
OK then, please proceed to do so. – Littlefoot Mar 19 '19 at 08:11

How to export full schema without any constraint issues for one month date range

1 Answers1