急!!!!!求助 oracle导入问题 oracle数据库oracle11g 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create tablespace huaihua_z datafile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_z.dbf' size 5m autoextend on ; create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by huaihua default tablespace huaihua_z temporary tablespace huaihua_temp_z; grant connect to huaihua; grant resource to huaihua; imp system/Whq442279@orcl fromuser=system touser=huaihua ignore=y buffer=409600 file=e:\zbc_2013_11_27.dmp create tablespace huaihua_z datafile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_z.dbf' size 5m autoextend on ; create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by 123456 default tablespace huaihua_z temporary tablespace huaihua_temp_z; grant connect to huaihua; grant resource to huaihua; 不同用户名导入:imp system/123456@orcl fromuser=system touser=huaihua ignore=y buffer=409600 file=e:\zbc_2013_11_27.dmp create tablespace huaihua_z datafile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_z.dbf' size 5m autoextend on ; create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by 123456 default tablespace huaihua_z temporary tablespace huaihua_temp_z; grant connect to huaihua; grant resource to huaihua; imp system/123456@orcl fromuser=system touser=huaihua ignore=y buffer=409600 file=e:\zbc_2013_11_27.dmp red hat linux 5上安装oracle 10g遇到的问题 监听和实例如何关联? oralce群集问题 在同一块磁盘上作分区表有意义么? ORACLE在一个SQL怎么对一个字段升序同时对另一个字段降序排序呢? 如何在oracle的存储过程中使用临时表? insert表 速度非常之慢 function编译错误?我找不到,请大家看看 两个问题! oracle安装时出现的问题 求助一下错误原因,oracle输入代码后就出现如下错误 查询oracle两表中的相同数据
create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by huaihua default tablespace huaihua_z temporary tablespace huaihua_temp_z; grant connect to huaihua; grant resource to huaihua;
imp system/Whq442279@orcl fromuser=system touser=huaihua ignore
=y buffer=409600 file=e:\zbc_2013_11_27.dmp
create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by 123456 default tablespace huaihua_z temporary tablespace huaihua_temp_z;
grant connect to huaihua; grant resource to huaihua;
不同用户名导入:imp system/123456@orcl fromuser=system touser=huaihua ignore
=y buffer=409600 file=e:\zbc_2013_11_27.dmp
create temporary tablespace huaihua_temp_z tempfile 'E:\oracle_112040_MSWIN-x86-64\formSpace\huaihua_temp_z.dbf' size 5m autoextend on; create user huaihua identified by 123456 default tablespace huaihua_z temporary tablespace huaihua_temp_z;
grant connect to huaihua; grant resource to huaihua;
imp system/123456@orcl fromuser=system touser=huaihua ignore
=y buffer=409600 file=e:\zbc_2013_11_27.dmp