OraFAQ Forum: Server Utilities » error when creating a new tablespace

Home » RDBMS Server » Server Utilities » error when creating a new tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error when creating a new tablespace [message #72741]

Fri, 10 October 2003 09:48

Sean Day
Messages: 7
Registered: October 2003

Junior Member

Can anyone help me with this error:

SQL> CREATE TABLESPACE BANKFRM DATAFILE 'BANKFRM' SIZE 20
CREATE TABLESPACE BANKFRM DATAFILE 'BANKFRM' SIZE 20m
*
ERROR at line 1:
ORA-01119: error in creating database file 'BANKFRM1'
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists

When we need to clean down a database we drop the user and then re-create it. We are using Oracle 8.1.7 Personal edition on Windows 2000 profesional.

Any help would be great

Sean

Report message to a moderator

Re: error when creating a new tablespace [message #72742 is a reply to message #72741]

Fri, 10 October 2003 09:55

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the tablespace already exist.
u dropped the user, so all the objects used by user is dropped.
NO need to create the tablespace.
if you insist, drop the tablespace and create new one
or create another tablesace with another datafile.

Report message to a moderator

Re: error when creating a new tablespace [message #73586 is a reply to message #72741]

Wed, 26 May 2004 05:05

Prateek Sachan
Messages: 6
Registered: May 2004

Junior Member

0ra-01119 is an of insufficient disk space

please increase the space in that folder if the platform is unix or if on windows then try freeing some space on the drive.

Report message to a moderator

Previous Topic:	Urgent:-CONSTRAINTS
Next Topic:	importing full database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:13:48 CDT 2024