OraFAQ Forum: Server Administration » Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace?

Home » RDBMS Server » Server Administration » Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace? [message #60308]

Sat, 31 January 2004 11:31

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

Is it possible to have a Locally Managed Tablespace (LMT) on Oracle 8i? If yes: how to migrate an LMT with objects in it to a Dictionary Managed Tablespace (DMT) on Oracle 8i?

Is it possible to have some "documentation" about the fundamental concepts between LMT and DMT? Can I download some doc from somewhere?

Many thanks!

Best regards,

Patrick Tahiri.

Report message to a moderator

Re: Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace? [message #60319 is a reply to message #60308]

Mon, 02 February 2004 02:59

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Yes, you can have LMT tablespaces on 8i and 9i. You can convert between LMT and DMT like this:

SQL> exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts1');
PL/SQL procedure successfully completed.

SQL> exec dbms_space_admin.Tablespace_Migrate_FROM_Local('ts2');
PL/SQL procedure successfully completed.

For more info, read this article http://www.orafaq.com/articles/archives/000011.htm

Best regards.

Frank

Report message to a moderator

Re: Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace? [message #60337 is a reply to message #60319]

Mon, 02 February 2004 10:41

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Thank you very much for your answer!!

Should I install or configure something specific or special to be able to use dbms_space_admin and execute it? Is it coming with Oracle 8i and I can just run it?

Does this operation (heavy?) influence in any maner the objects and its data contained on the processed tablespace?

Again, many thanks for your great tips!

Best regards,

Patrick Tahiri.

PS: It seems not possible to define a locally managed tablespace with the AUTOALLOCATE option with Oracle 8i! I am right?

Report message to a moderator

Re: Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace? [message #61053 is a reply to message #60337]

Tue, 23 March 2004 18:38

sara khan
Messages: 1
Registered: March 2004

Junior Member

what are the diffrence between oracle 8i and oracle 9i.
what is the architecture of oracle 8i and oracle 9i.
what other new facilities thus oracle 9i provide more than the oracle 8i
etc.
and many more

Report message to a moderator