Home » RDBMS Server » Server Utilities » error in export
error in export [message #161096] Thu, 02 March 2006 00:20 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
C:\> EXP SYS/WELCOME123 FILE =c:\EXPVEN.DMP
GRANTS=Y TABLES=(SCOTT.EMP,SCOTT.DEPT)

Export: Release 9.2.0.1.0 - Production on Thu Mar 2 11:51:11 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


EXP-00056: ORACLE error 28009 encountered
ORA-28009: connection to sys should be as sysdba or sysoper


hi,

what is the error ? how can i login as sysdba ??

Report message to a moderator

Re: error in export [message #161115 is a reply to message #161096] Thu, 02 March 2006 01:16 Go to previous messageGo to next message
sach_sumit
Messages: 9
Registered: September 2005
Junior Member
hi


C:\> EXP SYS/WELCOME123 FILE =c:\EXPVEN.DMP


use

C:\> exp 'sys/welcome123 as sysdba' file=c:\expven.dmp

regards
Sumit Sachdeva

Report message to a moderator

Re: error in export [message #161117 is a reply to message #161115] Thu, 02 March 2006 01:25 Go to previous message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
thanks for your help ... it is working fine ...

Report message to a moderator

Previous Topic: export/import and files size
Next Topic: import issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 08:14:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.