Link to home
Create AccountLog in
Avatar of sitg
sitgFlag for Iceland

asked on

Oracle 10g tablespace issue


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.

Avatar of Sean Stuber
Sean Stuber

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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?