Search

My notebook

Category

Oracle

Forgot SYS password in oracle 11g

Log on to your Windows server as a member of the Administrators group or a member of the ORA_DBA group.
Try the below steps

sqlplus /nolog
connect / as sysdba
Once connected, you can change the SYS password to something you know:
ALTER USER sys IDENTIFIED BY new_password;

Advertisements

Show tables in Oracle

Connect to the database:
sqlplus username/password@database-name

To list all tables owned by the current user, type:
select tablespace_name, table_name from user_tables;

To list all tables in a database:
select tablespace_name, table_name from dba_tables;

To list all tables accessible to the current user, type:
select tablespace_name, table_name from all_tables;

 

From http://onewebsql.com/

 

OR

 

  • SELECT owner, table_name FROM dba_tables;
  • SELECT owner, table_name FROM all_tables;
  • SELECT table_name FROM user_tables;
  • SELECT view_name FROM all_views;

Create a free website or blog at WordPress.com.

Up ↑