This content has been marked as final. Show 7 replies
You are logged in as sysman,
Check the user from sql prompt.
yes I'm logged in in isqlplus as sysman.
Because the tuning set is owned by SYS and when you log in as sysdba from sqlplus you log in as SYS. So if you want to execute this from iSqlplus , log in as sys and execute.
Hope this helps.
PS: iSQL*Plus has been dropped by Oracle ... time to move to SQL*Developer.
thank you damorgan.
I used then sqldeveloper but two problems :
1-when exporting to any kind of file i receive : ora-00936 missing expression.
2- I can copy/past to a file but without any column head. Any workaround ?
2- I can copy/past to a file but without any column head. Any workaround ?please clarify what this means
I wanted to say column headline, name of each column.