| rajesh |
Posted: May 13, 2008 02:06:48 AM |
Total Post: 26
Joined: May, 2008
|
I have some doubts.
1. Can we alter extent management ( i.e. local to dictioniary and vice versa) of Tablespace after creation.
2. When I am giving the following statement I got error
Alter database drop datafile '/disk1/oradata/sai/ts1.dbf'
error : ORA-01900 - Logfile keyword expected at datafile'
3. In extent management if we consider local, we no need to specify max. extents clause. Then what is the difference between it and autoextent on.
your answers may be highly appreciated.
Rajesh
|
|
|
 Gitesh |
| Posted: May 13, 2008 02:34:00 AM |  |
|
Total Post: 322
Joined: May, 2005
|
How can you covert tablespace from dictionary managed to locally managed?
in locally managed tablespace there is no need to give parameters like pctfree,pctused.
Autoextend you can use for data file only not for segment.
|
|
|
|
|
| Murtuja |
| Posted: May 13, 2008 04:00:05 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Yes , You can convert DMT to LMT using DBMS_SPACE_ADMIN package
|
|
|
|
|
| dbavinod |
| Posted: May 13, 2008 04:09:40 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
check syntax for drop command
|
|
|
|
|
| dbavinod |
| Posted: May 13, 2008 04:11:33 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
AutoExtend as the name indicates when ever extent is required oracle server process will allocate automatically if space exists in Disk.if it is off in large trans u may get unable to allocate extent for object error.
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 04:34:43 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
for droping a datafile...
alter database drop datafile '/u01/datafile.dbf' offline drop;
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 04:39:01 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Why the error you got is..
error : ORA-01900 - Logfile keyword expected at datafile'
Cause
keyword missing
Action
supply missing keyword
|
|
|
|
|
| Gitesh |
| Posted: May 13, 2008 08:01:42 AM | |
|
Total Post: 322
Joined: May, 2005
|
Little correction in above command...
alter database drop datafile '/u01/datafile.dbf' offline drop;
Some mistake in above command..
use following command
alter database datafile '/u01/datafile.dbf' offline drop;
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 08:47:06 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Sorry Gitesh...
I accidiently typed that :)
|
|
|
|
|
| rajesh |
| Posted: May 14, 2008 02:14:36 AM | |
|
Total Post: 26
Joined: May, 2008
|
Thank you gitesh and gopu
Rajesh
|
|
|
|
|
| jogi |
| Posted: May 15, 2008 01:54:12 AM | |
|
Total Post: 21
Joined: Jul, 2007
|
Hi rajesh,
We can migrate from locally to dictionary or dictionary to locally after creating the tablespace.
execute DBMS_TABLESPACE_migrate_to_local("we")
or
execute DBMS_TABLESPACE_migrate_from_Dicationary("psp");
Prasad
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
