OraFAQ Forum: Server Utilities » previlleges required for exporting and importing

Home » RDBMS Server » Server Utilities » previlleges required for exporting and importing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

previlleges required for exporting and importing [message #7246]

Fri, 30 May 2003 03:36

shyamala
Messages: 11
Registered: May 2003

Junior Member

dear sir,
i was able to export and import the tables but the values in a table is not exported, i wanted to know what are the required system previlleges to be given & how?.
whether the database is overwriten or not? any configuration to be set.

Report message to a moderator

Re: previlleges required for exporting and importing [message #7249 is a reply to message #7246]

Fri, 30 May 2003 06:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you can do export and import , you DO have the right privs.
By defualt, every user ( owner) can export /imort his own objects only.
if you are exporing/importing objects owned by other users you may need additonal privs like IMP_FULL_DATDABASE and EXP_FULL_DATABASE

May be you are getting into some other issues.
please post a log of exp/imp sesion.

Report message to a moderator

Re: previlleges required for exporting and importing [message #7264 is a reply to message #7249]

Fri, 30 May 2003 20:58

shyamala
Messages: 11
Registered: May 2003

Junior Member

Hi,

thankyou for u r reply,

this is my export log file:

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
. exporting foreign function library names for user SHAKTI
. exporting object type definitions for user SHAKTI
About to export SHAKTI's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SHAKTI's tables via Direct Path ...
. . exporting table TEMP 2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

waiting for u r reply...

Report message to a moderator

Re: previlleges required for exporting and importing [message #7270 is a reply to message #7264]

Sat, 31 May 2003 23:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. login as sys and do this
GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;
2. logged in as sys grant exp_full_database to the user doin the export( may be it is already granted. do it again)
3. do the same(step1) toimp_full_database
4. grant again imp_full_database to the user

Report message to a moderator

Re: previlleges required for exporting and importing [message #7276 is a reply to message #7270]

Mon, 02 June 2003 03:15

shyamala
Messages: 11
Registered: May 2003

Junior Member

hi
i have tried the query u have given which is working fine. thank you very much.

shyamala

Report message to a moderator

Previous Topic:	why are the dba_views queries so much faster then the all_ or user_ views queries
Next Topic:	export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 16:54:51 CDT 2024