I accidentaly created a tablespace without giving required intial extent size i wanted. I just created a datafile for that tablespace with 500M. I want that tablespace intial extent to be 450m. What should i do now.
Printable View
I accidentaly created a tablespace without giving required intial extent size i wanted. I just created a datafile for that tablespace with 500M. I want that tablespace intial extent to be 450m. What should i do now.
You can just drop/recreate it OR issue:
alter tablespace (name) default storage (initial 450M ....);
The default storage of a tablespace may be "dangerous" if you don't specify the storage of segments created on that (becasue they by get the default storage of the tablespace)
However you can do as halo said.
If i drop the tablespace including contents, i will still have a datafile on operating system. If i remove that datafile will it lead to any complications once i shutdown and restart database ? I verified it on personal oracle everything looks fine, but still i want to know.
Put yuor tablespace offline;
Drop the tablespace including contents;
Remove the datafile from your file system.
If you correctly do those steps you have not any problems in shutting down and starting up your database.
However for every evenience you should take a backup of your controlfile before shutting down your DB with the command
ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Bye