Home

oracle db recovery

  • Category: 電腦相關
  • Last Updated: Monday, 08 November 2010 13:11
  • Published: Monday, 08 November 2010 13:04
  • Written by sam

1. sqlplus system/manager@toptest

drop user xxxxxx cascade;

exit

2. createdb xxx 1

3. imp system/manager@toptest fromuser=xxxx touser=xxx file=xxx.dmp ignore=y

4. p_zo

linux

  • Category: 電腦相關
  • Last Updated: Sunday, 07 November 2010 18:56
  • Published: Sunday, 07 November 2010 18:54
  • Written by sam

修改 hostname

1. vi /etc/hosts

2. vi/etc/sysconfig/network

3 hostname XXXX

4. 記得使用su root