Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export a sys table [!exp] on Linux

767685Mar 14 2012 — edited Mar 15 2012

Hi,

I want to truncate a table belong to sys schema, i.,e, WRI$_OPTSTAT_HISTGRM_HISTORY. To make the free space available in the tablespace SYSAUX- it's 80% full. Before truncating this table I want to export it, but !exp is not working for me when I want to provide sys / as sysdba.

OS=RHL.
# There is something little but of course tricky .

SQL> !exp

Export: Release 10.2.0.5.0 - Production on Wed Mar 14 12:51:53 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Username: sys / as sysdba

EXP-00004: invalid username or password
Username:

Thanks

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2012

Added on Mar 14 2012

#export, #general-database-discussions

6 comments

915 views