OraFAQ Forum: Server Utilities » question on datapump

Home » RDBMS Server » Server Utilities » question on datapump

Fri, 30 May 2014 14:48

kiranrathodkr916
Messages: 36
Registered: March 2014
Location: India

Member

If some object is being changed when data pump is run how will that object go into datapump file?

Fri, 30 May 2014 14:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the content of the object will be what existed at the start of the export.

Fri, 30 May 2014 15:02

kiranrathodkr916
Messages: 36
Registered: March 2014
Location: India

Member

the file is it will have last committed or last ddl data

is this statement right

[Updated on: Fri, 30 May 2014 15:04]

Fri, 30 May 2014 15:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It depends upon when "LAST" actually occurred.

Sat, 31 May 2014 00:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It also depends if you give the FLASHBACK_TIME or FLASHBACK_SCN parameter.

Previous Topic:	ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM
Next Topic:	Help Column masking/encrypting

Goto Forum:

]

Current Time: Mon Dec 23 03:00:37 CST 2024