查看表空间和数据文件的信息 select tablespace_name,file_name,ceil(bytes/1024/1024) mb from dba_data_files order by 1; 查看表空间空闲的 select s.tablespace_name 表空间, sum(s.bytes)/1024/1024 mb from dba_free_space s group by s.tablespace_na
查看表空间和数据文件的信息
select tablespace_name,file_name,ceil(bytes/1024/1024) mb
from dba_data_files order by 1;
查看表空间空闲的
select s.tablespace_name 表空间,
       sum(s.bytes)/1024/1024 mb
from dba_free_space s
group by s.tablespace_name
order by 2
创建表空间
create tablespace ecology logging datafile 'c:\oa_data\ecology.dbf'
size 1024m reuse extent management local segment space management auto;
--修改大小
alter database datafile ‘c:\oa_data\ecology.dbf’ resize 100m;
数据文件的自动扩展
select file_name,autoextensible,maxblocks,increment_by from dba_data_files;
改为自动扩展
alter database datafile 'c:\oa_data\ecology.dbf' autoextend on next 1m maxsize 2048m;
--删除用户
drop user ecology cascade;
-- 创建用户
create user ecology
  identified by ecology
  default tablespace ecology;
-- grant/revoke role privileges
grant connect to ecology;
grant resource to ecology;
grant dba to ecology;
--连接测试
sql> conn ecology/ecology
---测试创建表
sql> create table xjy_test (my_id number);
---插入数据
insert into xjy_test values (1);
delete from xjy_test;
commit;
---导入数据文件
imp ecology/ecology fromuser=ecology touser=ecology file=20140513_2.dmp  log=20140513_2.log ignore=y
遇到问题11g不能导入10g
http://www.cnblogs.com/alxc/archive/2011/03/25/1995279.html
这个文章解决
--问题1
空表没有导入
   select table_name from user_tables where num_rows=0;
---执行以下语句
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0
--把生成的结果执行
alter table fnasystemset allocate extent;
alter table budgetautomove allocate extent;
alter table taks_mainlinetask allocate extent;
alter table task_attention allocate extent;
---参考 http://vondon.iteye.com/blog/1316223
    exp 用户名/密码@数据库名 file=/home/oracle/exp.dmp log=/home/oracle/exp_smsrun.log  
--exp
 exp xxxx/xxxxxx owner=xxx file=xxxx.dmp