Home » RDBMS Server » Server Administration » oracle installation on windows
oracle installation on windows [message #198668] Wed, 18 October 2006 03:42 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
Hello All,
Not sure if this is the correct place for this message but here we go anyway.

Have installed oracle 8i onto windows 2000 server. The issue at hand is that admin user who performed the install is the only one that can import/export data to the database. Even if other windows users are created with the same rights they cannot perform import/export of data.

can anyone help, suggest what the problem could be?

regards

Report message to a moderator

Re: oracle installation on windows [message #198692 is a reply to message #198668] Wed, 18 October 2006 04:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
alanm wrote on Wed, 18 October 2006 03:42
admin user who performed the install is the only one that can import/export data to the database.

What type of error are you getting ?

Report message to a moderator

Re: oracle installation on windows [message #198823 is a reply to message #198668] Wed, 18 October 2006 12:31 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
for import or export operation .

user needs >>> full_exp_database or Full_imp_database privs.
if is better to run catexp.sql scripts before doing import or export operation.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm

Report message to a moderator

Previous Topic: Can a DBA see Server Process?
Next Topic: agent fails to start on oracle 9206
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:35:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.