drop user jyjt cascade
drop tablespace JYJT including contents and datafiles cascade constraint;
create user jyjt identified by jyjt;
grant dba,resource,connect to jyjt;
create tablespace jyjt datafile 'd:\jyjt.dbf' size 30700m;
alter user jyjt default tablespace JYJT;
select tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name = 'JYJT';
alter database datafile 'D:\JYJT.DBF' autoextend on;
select * from all_tables a where a.OWNER = upper('jyjt');
imp test_user/123456 file=D:\xxxx.dmp log =d:\xxx.txt full=y