Re: 2 Questions

Violin wrote:
>
> 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:

        [SNIP] c> 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

1. Do the following three things before running the import: Create the rollback segment tablespace Create the rollback segments Turn the rollback segments online.
2. You can find scripts that correctly calculate total and free space on the web. I use the one that is in ORA-SNAP on RHUBARBS' site. -- Jerry Gitomer Once I learned how to spell DBA, I became one.