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

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way.

In addition, export is NOT a backup method.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 04 05:06:31 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.