2 Questions

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 22 Jan 2000 02:04:23 GMT
Message-ID: <38890a33.720415@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 Fri Jan 21 2000 - 20:04:23 CST