1) drop user userA; then create user userA
2)
sql>set head off
sql>set feedback off
sql> spool c:\myDel.sql
sql> select 'delete from ' || table_name || ';' from user_tables;
sql>spool off
sql>@mydel.sql
sql>commit;
2)
sql>set head off
sql>set feedback off
sql> spool c:\myDel.sql
sql> select 'delete from ' || table_name || ';' from user_tables;
sql>spool off
sql>@mydel.sql
sql>commit;
再建立用户,再imp,
就可以了
2. drop userA
3. create userA
4. import userA with option rows=N