2 Questions
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
Name Status Size(M) Used(M) SYSTEM ONLINE 80.000 44.23680M - 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