oracle导入数据的方法

启动服务：services.msc

 

第一步开启监听程序：lsnrctl start

第二步

导出原来数据操作

Exp tc4_gctos_file/ok @tcmg       

导入操作：

Imp tc4_gctos_file/ok@orcl

导入文件： EXPDATA.DMP D:\TC4_gctos_file  ;如果遇到NO 根据实际情况改成YES在

在D:\TC4_GCTOS; TC4_GCTOS_CODE ; TC4_GCTOS_FILE;

 

 

修改C:\Program Files\HDSOFT\HD_TC_GCTOS_5.0\runtime下面的DATA

在NETWORKK中

# tnsnames.ora Network Configuration File:d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

 

ORCL =

 (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = wangli2011-PC)(PORT = 1521))

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orcl)

    )

  )

TCMG=

 (DESCRIPTION=

   (ADDRESS=

     (PROTOCOL=TCP)

     (HOST=192.168.102.58)

     (PORT=1521)

    )

   (CONNECT_DATA=

     (SERVER=dedicated)

     (SERVICE_NAME=orcl)

    )

  )

EXTPROC_CONNECTION_DATA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

   (CONNECT_DATA =

     (SID = PLSExtProc)

     (PRESENTATION = RO)

    )

  )