Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DMT and LMT
On Fri, 21 Mar 2003, Norman Dunbar wrote:
> Hi Hanne,
>
> your error 'ORA-12913 Cannot create dictionary managed tablespace' shows
> that you have a SYSTEM tablespace which is LMT and thus you are not
> allowed to have any other tablespaces which are DMT. 9i Release 2
> methinks !
Now, we have recreated our database, and evrything works fine. The DMT system tablespace worked well.
[..snipped a lot of import tips..]
> Trust me, doing it this way saves time on imports. If your import of a
> full dump file takes 10 hours then you could be importing 4 or 5
> different users when all you want is one.
Next time I will do it this way. Thanks!
regards Hanne
-- Hanne Midttun http://www.tihlde.org/~hannem English is not my native toungeReceived on Mon Mar 24 2003 - 06:07:30 CST