Hi
John,
Thanks so much for ur
advice.....never knew about that procedure before. By the
way,
could u please tell me what
do the allocation_unit, relative_fno within the paranthesis
mean ?? Or could u just
give me a document link where I can read more about this procedure
??
Regards,
Samir
Samir Sarkar<
BR>Oracle DBA - LennonT
eam
SchlumbergerSema
Email :
[EMAIL PROTECTED]
s
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418
Ext. 76217
Fax
: +44 (0) 115 - 957
6018
-----Original Message-----Hi
From: orantdba [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 15:40
To: Multiple recipients of list ORACLE-L
Subject: Re: Locally managed tablespaces
Any reason that this external consultant is not using the package
dbms_space_admin.tablespace_migrate_to_local procedure ??
This would seem a much cleaner method of doing this than the method they
are recommending.
From the plsql supplied reference.
TABLESPACE_MIGRATE_TO_LOCAL Procedure
Use this procedure to migrate the tablespace from dictionary managed format to locally managed format. Tablespaces migrated to locally managed format are user-managed.
Syntax
TABLESPACE_MIGRATE_TO_LOCAL(tablespace_name, allocation_unit, relative_fno)Hope this helps,
John
[EMAIL PROTECTED] wrote:
I have just heard today that an external consultant, who is coming to
upgrade software for our Student Records system next week, wants to unload
the live, test and training databases, and recreate them using locally
managed tablespaces.
I've been reading all the incredibly positive things oracle have to say
about this, but has anybody any real experience of using locally managed
tablespaces, and if so, are there any major disadvantages or knock-on
effects that I should be aware of? Apart from trying to find disk space to
unload each database to do this, would it have any additional space
implications?
Basically, I need to decide if I should let this go ahead.
Heather
___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________
