我在oracle中建一个用户rfiduser 默认的表空间设置为rfiduser
但我导入数据时，数据的表空间怎么还是user啊！sqlplus rfiduser/jky_rfid_123 as sysdba
一:
create directory rfidnew as 'd:\rfidnew';
二:
grant read,write on directory rfidnew to rfiduser;
三
impdp rfiduser/jky_rfid_123 directory=rfidnew dumpfile=myusertab1.dmp logfile=myusertab1.log tables=cc_info1,cc_info2,cc_car,cc_caifen,cc_recinfo,cc_accountinfo,cc_recinfo1,cc_user,road_info,managedep_info,ownerdep_info,tollstation_info,station_info,pikerate,vehicleregister,accountfreeze,accountthaw,tagreplace,ownerchange,vehiclelogout,vehiclecorrect,devicevindicate,devicelog,devicecontrol,enterrecord,record,exitrecord,trafficrecord,pikerecord,pikesplitrecord,invoiceprintrecord,blacklist,userinfo,temprec_info,milesplit_info,costsplit_info,InvalidTagRecord,BankAccount,deductRecord,temprec_info,synchronousrecord,delayexportrecord,feerate,accountrecharge,personuser,alarmlog,handiwork,systemlog,carchargeback,carbackout,transactionfaile,monthbalance那位高手能否帮忙解答下啊
但我导入数据时，数据的表空间怎么还是user啊！sqlplus rfiduser/jky_rfid_123 as sysdba
一:
create directory rfidnew as 'd:\rfidnew';
二:
grant read,write on directory rfidnew to rfiduser;
三
impdp rfiduser/jky_rfid_123 directory=rfidnew dumpfile=myusertab1.dmp logfile=myusertab1.log tables=cc_info1,cc_info2,cc_car,cc_caifen,cc_recinfo,cc_accountinfo,cc_recinfo1,cc_user,road_info,managedep_info,ownerdep_info,tollstation_info,station_info,pikerate,vehicleregister,accountfreeze,accountthaw,tagreplace,ownerchange,vehiclelogout,vehiclecorrect,devicevindicate,devicelog,devicecontrol,enterrecord,record,exitrecord,trafficrecord,pikerecord,pikesplitrecord,invoiceprintrecord,blacklist,userinfo,temprec_info,milesplit_info,costsplit_info,InvalidTagRecord,BankAccount,deductRecord,temprec_info,synchronousrecord,delayexportrecord,feerate,accountrecharge,personuser,alarmlog,handiwork,systemlog,carchargeback,carbackout,transactionfaile,monthbalance那位高手能否帮忙解答下啊
http://www.cnblogs.com/KissKnife/archive/2007/09/17/896459.html IMP数据到指定的表空间一直以来，我都认为只要指定用户的默认表空间，向该用户导入数据时，会自动进入到默认表空间。后来发现从System导出的dmp文件在导入时，即使指定新用户的默认表空间，还是要往System表空间中导数据。上网搜了一下，还是有解决方法的，常见的方法如下：SQL> create user myhuang identified by myhuang default tablespace myhuang;SQL> grant resource,connect to myhuang;SQL> grant dba to myhuang;//赋DBA权限SQL> revoke unlimited tablespace from myhuang;//撤销此权限SQL> alter user myhuang quota 0 on system;//将用户在System表空间的配额置为0SQL> alter user myhuang quota unlimited on myhuang;//设置在用户在myhuang表空间配额不受限。 经过上述设置后，就可以用imp导入数据，数据将会进入指定的myhuang表空间：C:\Documents and Settings\myhuang>imp system/123456@vdb fromuser=lnxh touser=myhuang file=G:\myhuang\lnxh.dmp ignore=y grants=n
如果不是，则impdp时加两个参数：remap_schema=原来帐户:rfiduser remap_tablespace=原来表空间:rfiduser如果是rfiduser导出，则只要第二个remap参数。
是个用户名，表示只从dump文件中抽取lnxh用户的数据，然后把这些数据导入到myhunag用户下
至于加在什么地方，都行啊。
比如：
impdp rfiduser/jky_rfid_123 directory=rfidnew dumpfile=myusertab1.dmp remap_ .... tables=...
下面就是一个下划线一直闪！这是怎么回事呢？