This content has been marked as final. Show 7 replies
I checked that there is no prob in db_file_name_convert parameter but in db_create_file_dest ='+DBDG' (test) or '+DBDG1' (test2) specified in pfile,
also unable to set multiple locations or diskgroups for this parameter (db_create_file_dest), plz suggest. if I set this parameter to '+HISTDG1' then all files getting created in HISTDG1 diskgroup. so plz tell me if we can set multiple location for db_create_file_dest parameter or some alternative soln....
as it can be null and is not realy needed
I should then use db_file_name_convert parameter like you had it initially.
Hopefully it will solve your problem
set set DB_FILE_CREATE_DEST=''
or if you use a pfile delete the line with DB_FILE_CREATE_DEST
Edited by: cliff64 on Mar 19, 2013 11:00 AM