日志记录

   工作了四年多了,一直想用博客的方式把自己的技术成长都记录下来,可每次都没有留下什么,总想写点有意义的东东,可每次都觉得没什么好写的,从现在开始,每天都写点,权当日志

-修改ORACLE字段名

ALTER TABLE table_name RENAME COLUMN old_column TO new_column;

二修改表名

1.RENAME old_tableName TO new_tableName;

2.ALTER TABLE old_tableName RENAME TO new_tableName;

三生成database link

tnsnames.ora配置

ORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = djx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle)
    )
  )

1.CREATE (PUBLIC) DATABASE LINK db_link CONNECT TO user IDENTIFIED BY password USING 'ORACLE';

2.CREATE (PUBLIC) DATABASE LINK db_lin CONNECT TO user IDENTIFIED BY password USING '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = djx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle)
    )
  )';