- 1). Open your Oracle Enterprise Manager session and connect to the database that contains your schema. Use your system administrator password to access the database. Changing table names requires elevated privileges.
- 2). Open an Oracle command window. Enter the following code into the console command line:
alter session current_schema=newSchema
Replace "newSchema" with your new name. - 3). Click the "Execute" button. This runs the SQL query and changes your table column name. Enterprise Manager returns a confirmation text that informs you that the table column has been changed.
SHARE