export import test

ora10glinux-> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ora10glinux-> ls
Desktop  hxg.dmp
ora10glinux-> imp help=y
ora10glinux-> imp userid=test2/test file=hxg.dmp  full=y grants=y indexes=y constraints=y buffer=102400000

Import: Release 10.2.0.1.0 - Production on Thu Oct 15 12:16:54 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by HXG, not by you

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing HXG's objects into TEST2
. importing HXG's objects into TEST2
. . importing table            "BANKRUNDATEBACKUP"        505 rows imported
. . importing table          "IMPORT_TARGETEDLIST"       4178 rows imported
. . importing table                         "TEST"    2606773 rows imported
. . importing table                        "TEST1"      65824 rows imported
. . importing table                       "TEST10"    5848064 rows imported
. . importing table                        "TEST2"     182752 rows imported
. . importing table                        "TEST3"      65824 rows imported
. . importing table                        "TEST4"      45688 rows imported
. . importing table                        "TEST5"      65824 rows imported
. . importing table                        "TEST6"      45688 rows imported
. . importing table                        "TEST7"      65824 rows imported
. . importing table                        "TEST8"    5848064 rows imported
. . importing table                      "TESTDMP"         10 rows imported
. . importing table                 "BANKRUNDATE2"        505 rows imported
. . importing table                  "BANKRUNDATE"         29 rows imported
. . importing table                 "DUPLICATETAB"          6 rows imported
. . importing table                         "BANK"         29 rows imported
Import terminated successfully without warnings.
ora10glinux->

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值