Laurent Schneider

Views:

SQL> create view v1 as select * from dual;

View created.

SQL> rename v1 to v2;

Table renamed.

SQL> create table t1 as select * from dual;

Table created.

SQL> rename t1 to t2;

Table renamed.

SQL> create sequence s1;

Sequence created.

SQL> rename s1 to s2;

Table renamed.


Synonyms:


SQL> create synonym syn1 for dual;

Synonym created.

SQL> rename syn1 to syn2;

Table renamed.

Constraints :


SQL> create table t(x number not null);

Table created.

SQL> select constraint_name
  2  from user_constraints
  3  where table_name='T';

CONSTRAINT_NAME
------------------------------
SYS_C0018686

SQL> alter table t rename constraint SYS_C0018682 to X_NOT_NULL;

Table altered.

Indexes :


SQL> create index i1 on t(x);

Index created.

SQL> alter index i1 rename to i2;

Index altered.

Columns :


SQL> alter table t rename column x to y;

Table altered.

Partitions :


SQL> create table t (x number, y number)
  2  partition by range(x)
  3    subpartition by hash(y) (
  4  partition p1 values less than(1)
  5    (subpartition sp1)
  6  ) ;

Table created.

SQL> alter table t rename partition p1 to p2;

Table altered.

Subpartitions:


SQL> alter table t rename subpartition sp1 to sp2;

Table altered.

Triggers:


SQL> create trigger tr1 after update on t 
  2  begin null; end;
  3  /

Trigger created.

SQL>
SQL> alter trigger tr1 rename to tr2;

Trigger altered.

For the dba, you can also rename datafile, logfile and even tablespaces (10g)



				
				

					
						This entry was posted
						 
						on Tuesday, May 22nd, 2007 at 14:03						and is filed under oracle,  sql.
						You can follow any responses to this entry through the RSS 2.0 feed. 

													You can leave a response, or trackback from your own site.

							

	Post to :
	del.icio.us
	- Digg it
	- Furl
	- reddit
	- Spurl