数据库导入步骤：

导入步骤

--创建表空间,已有表空间时不需要创建表空间，空间不够扩容即可
create tablespace nnc_data01 datafile 'D:\app\nnc_data01.dbf'
size 10240M autoextend on next 512M extent management local uniform size 256k;

--创建用户
create user ncc2105 identified by 1 default tablespace NNC_DATA01 temporary tablespace temp;

--给用户授权
GRANT connect,dba to ncc2105;

--创建dmp存放目录，将dmp放入指定文件夹下(手动创建与虚目录相同路径、名称的文件夹)
create directory expdpdir as 'E:\ncc2105';

--给用户授权读写
grant read,write on directory expdpdir to ncc2105;

-- cmd 运行 ，dmp文件放到指定目录下，导入
imp ncc2105/1@orcl file='E:\ncc2105\ncc2105.dmp' full=y

导入失败查询和解决方案：

提示：导入时常见的问题比较多，目前没有整理完全，最简单粗暴的方式还是删掉重新导吧<<。<<

--下面是导入报错，删掉重新导的语句
--查询用户、删除用户
select * from dba_users;
select * from dba_data_files;
drop user nc2105 cascade;
drop user ncc2105 cascade;

select * from dba_data_files;

drop tablespace ABC including contents and datafiles cascade constraint;

 select 'alter table '||t.table_name ||' truncate   partition ' || t.partition_name from USER_TAB_PARTITIONS t where t.table_name like 'F_%'
 
 
 --查询表空间使用情况
SELECT a.tablespace_name "表空间名",
       total "表空间大小",
       free "表空间剩余大小",
       (total - free) "表空间使用大小",
       total / (1024 * 1024 * 1024) "表空间大小(G)",
       free / (1024 * 1024 * 1024) "表空间剩余大小(G)",
       (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)",
       round((total - free) / total, 4) * 100 "使用率 %"
  FROM (SELECT tablespace_name, SUM(bytes) free
          FROM dba_free_space
         GROUP BY tablespace_name) a,
       (SELECT tablespace_name, SUM(bytes) total
          FROM dba_data_files
         GROUP BY tablespace_name) b
 WHERE a.tablespace_name = b.tablespace_name;
--删除表空间
 drop tablespace NNC_DATA01 including contents and datafiles;
 
 drop tablespace NNC_DATA01 including contents and datafiles cascade constraint;