Home » RDBMS Server » Server Administration » Oracle XML DB (Oracle 9i r2, Windows XP)
Oracle XML DB [message #415353] Mon, 27 July 2009 06:22 Go to next message
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 149 times)
Re: Oracle XML DB [message #415376 is a reply to message #415353] Mon, 27 July 2009 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Oracle XML DB [message #415396 is a reply to message #415353] Mon, 27 July 2009 09:54 Go to previous messageGo to next message
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
Re: Oracle XML DB [message #415408 is a reply to message #415396] Mon, 27 July 2009 10:27 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Oracle XML DB [message #415469 is a reply to message #415353] Tue, 28 July 2009 00:41 Go to previous messageGo to next message
arifkapucu
Messages: 6
Registered: October 2005
Junior Member
if i create TEST directory in C:\oracle\oradata\ there is no problem to install xml db. but i want dbca to use E:\TEST directory.
Re: Oracle XML DB [message #415666 is a reply to message #415469] Tue, 28 July 2009 09:55 Go to previous message
JackyShu
Messages: 25
Registered: May 2008
Junior Member
was wondering whether this is an xml issue, do you have problem to create table space under e:\test? or have you tried to install xml db manually?
Previous Topic: Transaction Tracer in Oracle
Next Topic: Shared Pool Size More Than Expected
Goto Forum:
  


Current Time: Sat Dec 10 15:05:51 CST 2016

Total time taken to generate the page: 0.06244 seconds