Home » RDBMS Server » Server Utilities » EXPort (without Mat view logs) (Oracle10g, Win2003)
EXPort (without Mat view logs) [message #352502] Wed, 08 October 2008 01:36 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Hi

Is there a way to take EXPort without "materialized view logs", as these logs cause error in IMPort and some time even terminate IMPort.

It will be equally well for me if i got a way to completely exclude "materialized view & materialized view logs" from EXPort.

Some one please guide me the way to exclude them from IMP or EXP?

Wishes
Re: EXPort (without Mat view logs) [message #352504 is a reply to message #352502] Wed, 08 October 2008 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way.

In addition, export is NOT a backup method.

Regards
Michel
Re: EXPort (without Mat view logs) [message #352509 is a reply to message #352504] Wed, 08 October 2008 02:02 Go to previous message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Additionally when ever I IMPort a user some objects appear in non-compiled state, I compile them with my client tool, but I have to drop and recreate materialized view every time.
Can come one have an improved way to get IMPort with materialized view?

Wisehs
Previous Topic: Reg the dump file fails to import
Next Topic: Importing data to table
Goto Forum:
  


Current Time: Tue Dec 24 10:37:26 CST 2024