Home » RDBMS Server » Server Administration » create a tablespace in solaris OS
create a tablespace in solaris OS [message #191795] Fri, 08 September 2006 03:16 Go to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
i have created a tablespace (oracle 10g), OS is Solaris


Create tablespace astra datafile '\export\xyz\abc\gau.DBF' size 1024M;




but it is giving the errors ORA-0119 and ORA-27044 and also

Intel SVR4 UNIX Error 28: No space left on device

i know The steps for creating tablespaces vary by operating system.

I was able to create one on windows yesterday, but there is

some problem with solaris, will anyone please tell me how

to do it in solaris ?
Re: create a tablespace in solaris OS [message #191803 is a reply to message #191795] Fri, 08 September 2006 03:38 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

-->Intel SVR4 UNIX Error 28: No space left on device

The message reflects that the filesystem does not enough space. Are you sure you have enough free space on the file system.
Re: create a tablespace in solaris OS [message #191814 is a reply to message #191795] Fri, 08 September 2006 04:15 Go to previous messageGo to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
yes i have enough free space

i gave df -k command to see it, and i calculated the available

free space (given in kb)..i have enough free space to store

my datafiles.
Re: create a tablespace in solaris OS [message #191819 is a reply to message #191795] Fri, 08 September 2006 04:27 Go to previous messageGo to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
no

for oracle, i have only 5675 kb !!!

i will delete unwanted files and let you know


Re: create a tablespace in solaris OS [message #193935 is a reply to message #191795] Wed, 20 September 2006 00:45 Go to previous message
Shamsher
Messages: 18
Registered: September 2006
Junior Member
Pl check

'\export\xyz\abc\gau.DBF' Windows format

'/export/xyz/abc/gau.DBF' Solaris format.


Thanks and Regards
Shamsheer

Previous Topic: Rename a oracle database
Next Topic: how do i create Heterogeneous services.
Goto Forum:
  


Current Time: Sat Dec 03 08:26:09 CST 2016

Total time taken to generate the page: 0.24575 seconds