| exporting policies [message #161524] |
Sun, 05 March 2006 23:03  |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
Hi,
I am using Oracle version 9.2.0.6.0
When I export the data, policies are not exported and some error is there like,
exp-000079: Data in table "string" is protected. Conventional path may only be exporting partial table.
And when I import the table, I am not able to import the policy.
I tried by exporting the table with sys user. So I was able to suppress the error but again after importing I am not getting the policy defined on the table.
So is there any way that I can exp/imp policies defined on the tables? Or do I need to copy it separately?
Kinjal.
|
|
|
|
|
|
| Re: exporting policies [message #161546 is a reply to message #161524] |
Mon, 06 March 2006 00:26  |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
I exported the table as follows,
oracle@mcplapp:~> exp file=/brndata/adv_sys.dmp log=/brndata/adv_sys.log tables='ADVANCES'
Export: Release 9.2.0.6.0 - Production on Mon Mar 6 12:02:35 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys/sys_pwd as sysdba
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table ADVANCES 219 rows exported
Export terminated successfully without warnings.
and then imported using following string,
imp file=/bkup/adv_sys.dmp fromuser=sys touser=sys
Import: Release 9.2.0.6.0 - Production on Thu Mar 9 03:04:54 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys/sys123 as sysdba
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table "ADVANCES" 219 rows imported
Import terminated successfully without warnings.
Kinjal.
|
|
|
|
|
|
| Re: exporting policies [message #161576 is a reply to message #161524] |
Mon, 06 March 2006 02:06 |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
My object is not in sys schema. Only thing is I have exported using sys user to suppress the error.
I tried to import in another user but when it didn't worked, I tried to import in sys user of my another database.
Still the policies are not imported.
And I saw the link and saw that some 'Exempt Access Policy' privilege is needed but when I checked in the database, there is no privilege named exempt access policy.
So is this the reason behind it or something else is there?
What should I do to solve this?
Kinjal
|
|
|
|
| Re: exporting policies [message #161578 is a reply to message #161576] |
Mon, 06 March 2006 02:13 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Based on your posting,
You are exporting an object in SYS schema ( you are missing the owner clause) and importing back to sys.
sys@9i > grant EXEMPT ACCESS POLICY to scott;
Grant succeeded. |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
