Don't drop the database. You can DROP USER CASCADE or truncate the tables
and use the IGNORE=Y option.
Violin wrote in message <38890a33.720415_at_172.16.7.5>...
>Hello dear all,
>
>I have 2 questions and need help....
>
>1.Do you ever try to do full import? I try but .... errors.
> First I do a full export with system,then I drop my database,
> and recreate one,only execute catalog.sql and catproc.sql.
> (after executing,there is one datafile,and one system rollback segment
> on system tablespace.)
>
> But when I try to imp80 system/manager file=c:\temp\full.dmp full=y.
> The tablespaces and rollback segment are imported fine,
> BUT the rollback segments were not online,so ROWS were not be imported.
> (Only schemas imported.)
> Errors are:
> . importing SCOTT's objects into SCOTT
> . . importing table "EMP"
> IMP-00058: ORACLE error 1552 encountered
> ORA-01552: cannot use system rollback segment for non-system tablespace
>'USER_DATA'
>
> I try to imprt by show=y,check for the create rollback segment :
>"CREATE ROLLBACK SEGMENT SYSROL STORAGE (INITIAL 102400 NEXT 102400
MINEXTEN"
> "TS 2 MAXEXTENTS 121) TABLESPACE "SYSTEM""
> "CREATE PUBLIC ROLLBACK SEGMENT RBS01 STORAGE (INITIAL 1048576 NEXT
1054720 "
> "MINEXTENTS 5 MAXEXTENTS 121) TABLESPACE "ROLLBACK_DATA""
> "CREATE PUBLIC ROLLBACK SEGMENT RBS02 STORAGE (INITIAL 1048576 NEXT
1054720 "
> "MINEXTENTS 5 MAXEXTENTS 121) TABLESPACE "ROLLBACK_DATA""
>
> These rollback segments were not turned to online,so the following
import
> data were not successful.
> What's wrong with my full.dmp or the rollback segments?
>
>2.When I use storage manager for monitor tablespaces,it calculates used
MBytes
>for each tablespace.
> But what's the formula for counting used storage for tablespace?
> I try the script:
> select tablespace_name,sum(bytes) from dba_free_space
> group by tablespace_name;
>
> TABLESPACE_NAME SUM(BYTES)
> ---------------------------------- --------------------
> SYSTEM 37500928
>
> But the result is different from storage manager,
> Name Status Size(M) Used(M)
> SYSTEM ONLINE 80.000 44.236
> 80M - 44.236M = 35.764(M)
>
> So how do I calculate used MBytes for each tablespace by script?
>
>Thank you for any suggestion.
>Best Regards.
>
>Violin.
>violin.hsiao_at_mail.pouchen.com.tw
Received on Mon Feb 14 2000 - 05:07:21 CST
