| ORA-00439 [message #330578] |
Mon, 30 June 2008 09:09  |
dillango
Messages: 145
Registered: January 2008
|
Senior Member |
|
|
Dear All,
I have problem while importing the dump file.
I have exported the dump file from the Server for a particular user and the same I tried to import in my personal computer.
while I importing, I am getting an error "0RA-00439 Feature not enabled: Materialized view rewrite"
However, I could see all the tables, procedures, functions perfectly imported with all the rows.
Note: I am using the same version for both Server and my personal system. Tablespace name, datafile name, user name also same like Server.
Is there anything I have to concentrate while exporting the tables to overcome this problem?
Please have your suggestion.
ILANGO
|
|
|
|
|
|
|
|
| Re: ORA-00439 [message #330590 is a reply to message #330588] |
Mon, 30 June 2008 09:33  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>I did not find the file as initsid.ora.
What i meant is, init< yourSID >.ora
You can manually check the file
or
query the existing values from sqlplus.
Check if these are set in your 'personal' database and 'other' database.
dbadmin@xxx > show parameter query_rewrite
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_enabled string true
query_rewrite_integrity string trusted
[Updated on: Mon, 30 June 2008 09:35] Report message to a moderator |
|
|
|
|
|
| Re: ORA-00439 [message #330598 is a reply to message #330594] |
Mon, 30 June 2008 09:49 |
|
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
In future, if possible, please post the output here (copy and paste) instead of attaching every other response.
It seems that the parameter is set to false.
| Quote: |
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_enabled string false
|
set the parameter to true, bounce the database and try again.
[Updated on: Mon, 30 June 2008 09:53] Report message to a moderator |
|
|
|
| Re: ORA-00439 [message #330606 is a reply to message #330598] |
Mon, 30 June 2008 09:59 |
dillango
Messages: 145
Registered: January 2008
|
Senior Member |
|
|
Sorry Mr.Mahesh,
I tried to paste but it was not proper (may be I don't know how to do it) that is why I attached the file.
How to set the paramert to True? change the init.ora file?
Regards,
ILANGO
|
|
|
|
|
|
| Re: ORA-00439 [message #330612 is a reply to message #330606] |
Mon, 30 June 2008 10:15 |
|
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Yes.
Edit file d:\oracle\admin\walaa\pfile\init.ora
Add entry query_rewrite_enabled=true
Restart the database.
Try again.
PS:
Next time, search before asking.
These questions are asked and answered many many times.
Search this forum/google.
And I do not prefer to be addressed as Mr.Mahesh. 
Please replace('Mr.Mahesh','Mr.')
[Updated on: Mon, 30 June 2008 10:20] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
