OraFAQ Forum: Server Utilities » export from a non-dba-user

Home » RDBMS Server » Server Utilities » export from a non-dba-user

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

export from a non-dba-user [message #110180]

Thu, 03 March 2005 19:46

sprgrmmr
Messages: 1
Registered: March 2005

Junior Member

Hi,
can I use exp utility from a non-dba-user?
thanks.

Report message to a moderator

Re: export from a non-dba-user [message #111477 is a reply to message #110180]

Wed, 16 March 2005 12:03

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Yes, it should work. Have you tried yourself?

exp scott/tiger tables=emp statistics=none

Export: Release 10.1.0.2.0 - Production on Wed Mar 16 19:34:54 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.

Best regards.

Frank

Report message to a moderator

Re: export from a non-dba-user [message #111526 is a reply to message #111477]

Thu, 17 March 2005 02:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Frank Naude wrote on Wed, 16 March 2005 19:03

Yes, it should work. Have you tried yourself?

Report message to a moderator

Previous Topic:	Importing an 8i dump file into a 9i database
Next Topic:	Sqlldr NVL Direct Load

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:28:00 CDT 2024