This forum is currently locked. You can't register or post questions at this time. (read more)

data export

All posts relating to Oracle database administration.

Moderator: Tim...

safazaurs
Member
Posts: 7
Joined: Mon Mar 04, 2013 1:05 pm

data export

Postby safazaurs » Tue Apr 02, 2013 1:29 pm

Hi.
I came here for an advise. I need to get only data from date interval, for example x --> y, or another variant only date from x --> now.
What's the best way to do it? I came across date expdp allows to use flasback scn, but I don't have any idea, how to check how to use that.

Tom

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: data export

Postby Tim... » Tue Apr 02, 2013 1:47 pm

Hi.

It depends what you are trying to achieve. Does the data itself have oms way to indicate it is of a certain date? Like maybe a create_date or updated_date column? If that were the case you could export using a WHERE clause that limits the data to a specific time frame...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

safazaurs
Member
Posts: 7
Joined: Mon Mar 04, 2013 1:05 pm

Re: data export

Postby safazaurs » Tue Apr 02, 2013 1:50 pm

Well.
I need full database data from one time to another, it could be from, for example, yesterday till now. How can I achive it?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: data export

Postby Tim... » Tue Apr 02, 2013 2:29 pm

Hi.

"Full database data" doesn't really make sense as that would include changes in the internal schemas. Do you really mean changed data in a whole schema?

I don't think that is possible using the default tool set. If you wanted the data as it looked in the past you could use flashback, but that will not allow you to only pull out the changes since that time to now.

The easiest way to track these data changes is to done of the following:

1) Use change data capture to capture the changes.
2) Track the changes yourself by adding create_date and/or modified_date columns to the tables. These can then be targeted in exports using the WHERE clause.

For something that has already happened, you can't retrofit this.

You only other options then are to mine the archived redo logs to identify DML that has occurred. That is going to be very time consuming and labor intensive.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron