sitg
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?