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: 282
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

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 ?
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
Previous Topic: Can a DBA see Server Process?
Next Topic: agent fails to start on oracle 9206
Goto Forum:
  


Current Time: Thu Dec 08 04:01:42 CST 2016

Total time taken to generate the page: 0.11220 seconds