Home » RDBMS Server » Server Administration » Tablespace Extent Management
Tablespace Extent Management [message #51652] Tue, 04 June 2002 22:44 Go to next message
Pravin Raharekar
Messages: 18
Registered: April 2002
Junior Member
Hi all,

Oracle allows us to manage Tablespace Extents by using Local or Dictionary managed. I have created a Tablespace using Dictionary Managed Extent, now I want to change it to Local Managed. Does Oracle allows me to do so. If yes please tell me the steps to do this.

Thanks in advance.

Pravin

Report message to a moderator

Re: Tablespace Extent Management [message #51654 is a reply to message #51652] Wed, 05 June 2002 02:28 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I believe it is possible, but can't tell you how. Try Oracle Metalink or OTN (otn.oracle.com).

MHE

Report message to a moderator

Re: Tablespace Extent Management [message #51662 is a reply to message #51652] Wed, 05 June 2002 06:22 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
dbms_space_admin.tablespace_migrate_to_local()
dbms_space_admin.tablespace_migrate_from_local()

Report message to a moderator

Previous Topic: Re: i Have dumps to clear all papers
Next Topic: Re: ocp sql & pl/sql - dumps
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 18:54:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.