asked on Oracle 10g tablespace issue
Hi,
When i am creating a tablespace with the size of 2G in Oracle 10g, its taking long time to create.
Even it is not completed in 20 mins.
Please advice what to do.
Regards,
When i am creating a tablespace with the size of 2G in Oracle 10g, its taking long time to create.
Even it is not completed in 20 mins.
Please advice what to do.
Regards,
Oracle DatabaseEnterprise Software
Last Comment
David VanZandt
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What kind of device is the file on? SAN, NAS, or local attached Disk?
Please post the relevant section of your alert log, in which the create tablespace DDL is issued and the resulting messages. What happens after 20 minutes - is the command being aborted by the user? Can you successfully create a smaller datafile, say 5 Gb? And of course, are you absolutely sure the target file system(s) have sufficient free space?