How modify username in oracle

oracleoracle10goracle9i

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table?
I use oracle 9.

Best Answer

In Oracle, as of version 11.2, you can't rename a schema (=user). See this discussion on AskTom for a workaround: you would export the user, reimport with the good name (using FROMUSER and TOUSER). All references (if any) in pl/sql code will have to be updated manually. Grants and public synonyms will have to be recreated separately.

Related Solutions

ORA-12705: Cannot access NLS data files or invalid environment specified

I figured out that that you could pass that two params to your Java app to resolve the issue:

-Duser.country=en -Duser.language=en

You could configure the values at environment variable level as well (depends from your OS).

Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)

These columns are all coming from the V$SQL_PLAN table, so you can use the documentation for that view. The documentation is somewhat limited, however, because exactly how the optimizer makes some of these estimates is very complicated, depending on the specific operation, system statistics, object statistics, and optimizer parameters among other things. And every version of Oracle will likely calculate things a bit differently because the optimizer group is constantly tweaking their formulas. Jonathan Lewis's Cost-Based Oracle Fundamentals is the most comprehensive source for learning exactly how the optimizer costs different operations.

Best Answer

Related Solutions

ORA-12705: Cannot access NLS data files or invalid environment specified

Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)

Related Topic