2 Questions

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 2000/01/22
Message-ID: <38890a33.720415_at_172.16.7.5>#1/1


[Quoted] Hello dear all,

[Quoted] 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:
[Quoted]     . 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'      [Quoted]     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""
[Quoted] "CREATE PUBLIC ROLLBACK SEGMENT RBS02 STORAGE (INITIAL 1048576 NEXT 1054720 "
"MINEXTENTS 5 MAXEXTENTS 121) TABLESPACE "ROLLBACK_DATA""
     [Quoted]   These rollback segments were not turned to online,so the following import  data were not successful.
[Quoted]   What's wrong with my full.dmp or the rollback segments?

2.When I use storage manager for monitor tablespaces,it calculates used MBytes [Quoted] for each tablespace.

[Quoted]    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 Sat Jan 22 2000 - 00:00:00 CET

Original text of this message