OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle XML DB (Oracle 9i r2, Windows XP)

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

Oracle XML DB [message #415353]

Mon, 27 July 2009 06:22

arifkapucu
Messages: 6
Registered: October 2005

Junior Member

Hi,

i want to install and configure xml db component on existing database(TEST) by using the screens in Database Configuration Assistant. When i select "XML DB" and click "finish", i get an error "Ora-01119 error in creating database file "c:\oracle\oradata\TEST\xdb01.dbf..."
The default path of the test database files is in E:\TEST but dbca is creating xdb01.dbf in c:\oracle\oradata\TEST\ location.
I used "alter system set db_create_file_dest='e:\test';" command to set default directory but it always create it in c:\oracle\oradata\TEST.

How can i change the location for xml db?

Thanks

Attachment: 4.gif
(Size: 40.16KB, Downloaded 819 times)

Report message to a moderator

Re: Oracle XML DB [message #415376 is a reply to message #415353]

Mon, 27 July 2009 08:26

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-01119: error in creating database file '%s'
 *Cause:  Usually due to not having enough space on the device.
 *Action:

Regards
Michel

Report message to a moderator

Re: Oracle XML DB [message #415396 is a reply to message #415353]

Mon, 27 July 2009 09:54

arifkapucu
Messages: 6
Registered: October 2005

Junior Member

No. There is enough space in c: drive.
dbca is creating xdb01.dbf in c:\oracle\oradata\TEST\ but TEST directory in specified location(c:\oracle\oradata) doesn't exist so i get an error.
i want dbca to create xdb01.dbf file in E:\TEST

Report message to a moderator

Re: Oracle XML DB [message #415408 is a reply to message #415396]

Mon, 27 July 2009 10:27

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

27040, 00000, "skgfrcre: create error, unable to create file"
// *Cause:  create system call returned an error, unable to create file
// *Action: verify filename, and permissions

Report message to a moderator