Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies


ADVERTISEMENT

JDeveloper, Java & XML :: Copy Files Into System Directory?

Mar 15, 2011

I am on a font manager project. One of the features is to install the new font file. My understanding by "install" is to copy the file to the system directory Windows/fonts (correct me if I am wrong in this part). When I tried to use the java copy file api to do so, not surprisingly I got the access denied exception.

1. How can I do a "force-copy" of file into the system directory?

2. If that's not proper way, how can I create a "shortcut" like a softlink of the file into the system directory?

View -1 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related

Server Administration :: File Format Of DBF Files

Apr 12, 2010

I want to know the file format of .dbf file.I want to open it in hex editor and want to read contents of that file from there.

View 4 Replies View Related

Client Tools :: Execute Multiple SQL Files In BAT File

Nov 27, 2012

Is it possible to execute multiple sql files in one .bat file?for single sql file it is working properly.

.bat file
-------------------------------

sqlplus /nolog @ c: est01.sql

View 5 Replies View Related

Server Administration :: Split 30GB DBF File Into 6 - 5GB Files?

Dec 27, 2011

We have a tablespace with one 30GB datafile. We would like to add 5 more datafiles then re-size the original to make six 5GB datafiles.

View 6 Replies View Related

Server Administration :: Variable File Size For Archive Log Files

Dec 16, 2010

I'm facing problem with archive log file size, Archive logs are generated with only of 90m or 92m or 94m(Variable sizes of less than 100m), Although i had set 100m for each of my redo log file. Here i'm providing my create db script for your reference. I want to know why the log switches before it reaches 100m.Is there any connection of intial 10m for my .dbf files.

create database mydev
maxlogmembers 3
maxloghistory 100
maxdatafiles 50
maxinstances 1
logfile

[Code]....

View 14 Replies View Related

How To Mount A Database From Dbf And Ctl Files

May 20, 2013

I recovered dbf and ctl files, how to mount that database again. Using oracle 9i.

View 1 Replies View Related

XE :: Recovering The Database From DBF Files

Oct 4, 2012

We have a customer that was backing up his data by copying the oracle data XE folder (all .dbf files) to a backup drive. His server crashed and he formatted it and reinstalled the database 11g from scratch.

Now he needs to re-attach the .DBF files, is there a way?

View 1 Replies View Related

Backup & Recovery :: Restore From Newer Control File And Archived Redo Log Files?

Mar 29, 2011

I've got a legacy SAP system with oracle 8i on Tru64. No changes at all are made but for legal reasons we have to keep it up and running.

we currently do a full backup monthly by shutting down oracle and doing a backup of all the files to tape and that takes around 12 hours.

If I stop doing the full backup and I only backup the control file and the archived redo log files every month and I had to restore the full database years from now, would I be able to restore the database using the last full monthly backup and use the latest control file and archived redo log files?

View 5 Replies View Related

Build Database From Backup Files

Aug 3, 2011

I am an absolute neophyte at this. I'm fairly good at SQL, but have not administrated a database before.

I am trying to take a backup from our production database and restore it to a fresh install of Oracle 10.2 on a Windows 2003 server using RMAN - but I am not getting very far. Software versions are all the same. I have access to the manuals, but it seems like every link I follow adds more questions than it answers.

I have gone through the wizard and set up oracle on the new box - that all seemed to go smoothly. In order for this to work, do I need to set up the database with the same DBID as the one in the backup files? Or is there a way to import the data from the backup and have it build the database from those files?

I'm not sure I'm even asking the right questions. Do any of y'all know of a tutorial that would walk me through this process step by step?

View 4 Replies View Related

SQL & PL/SQL :: Insert PDF Files Into Oracle Database

Mar 2, 2006

Here I am explaining the process of how I am trying to insert pdf file into oracle database.

create or replace directory files as 'c:/welcome/';

(physical directory is created in the system also., both in server and client machine)

Create or replace PROCEDURE procloadMetaPdf (Filename IN VARCHAR2) is
temp_blob blob:=empty_blob();
location BFILE;
Bytes_To_Load Integer:=0;
auto_Id number;
Begin

[Code]...

procudure creating successfully

but when executing

exec procloadMetaPdf('help.pdf');

displaying the following error:

ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 605
ORA-06512: at "SCOTT.PROCLOADMETAPDF", line 14
ORA-06512: at line 1

(line 14 is : DBMS_LOB.OPEN(location , DBMS_LOB.LOB_READONLY)

View 8 Replies View Related

SQL & PL/SQL :: Importing XML Files Into Oracle Database

Apr 25, 2010

I have a big problem that came up latly which is importing XML files into oracle database.The point is that I have extracted whole PostgreSQL database into XML files - 236 tables - 1 XML file for every table and now I'm about to import them into Oracle tables. First of all, I would like to point out that I already have the structure of all the tables in oracle database, the files only carry the data (records) that need to be imported into oracle.

I've been trying to make it running and I can't do anything more serious about it for over a week..I will show You all example:

insert into ps_sprawozdania(miesiac, umowa_rok, umowa_nr, nr_korekty, nazwa, data_potw, data_exp, status_potw)
select
extractvalue(column_value,'/NewDataSet/Cust/miesiac'),
extractvalue(column_value,'/NewDataSet/Cust/umowa_rok'),
extractvalue(column_value,'/NewDataSet/Cust/umowa_nr'),
extractvalue(column_value,'/NewDataSet/Cust/nr_korekty'),
extractvalue(column_value,'/NewDataSet/Cust/nazwa'),
extractvalue(column_value,'/NewDataSet/Cust/data_potw'),
extractvalue(column_value,'/NewDataSet/Cust/data_exp'),
extractvalue(column_value,'/NewDataSet/Cust/status_potw')
from table(xmlsequence(xmltype(bfilename('c: est','ps_sprawozdania.xml'))));

That was one of my attempts to import data from file "ps_sprawozdania.xml" into table "ps_sprawozdnaia" into oracle. Here are 2 records from the XML file to show you Its structure

<NewDataSet>
<Cust>
<miesiac>7</miesiac>
<umowa_rok>2008</umowa_rok>
<umowa_nr>051/210412/01/000/08</umowa_nr>
<nr_korekty>0</nr_korekty>
<nazwa>Sprawozdanie z realizacji umowy nr 051/210412/01/000/08 za miesiąc Lipiec</nazwa>
[code]....

handle with XML data, not XML files.

View 39 Replies View Related

How To Transfer Log Files Into Database Table

Dec 20, 2012

I have a requirement. My Front end is Oracle Application. If any user deletes the data from front end screen. One log file should be generated. That file will save in one folder in my server. And That log file consists which code is deleted. And the user name who deleted the code, time and deleting status..

Now my requirement is i have to develop a report to display the log file data. But i don't have a database table to retrieve the data. The data consists Log files. How to transfer the Log files in DB table.

View 4 Replies View Related

Store Video Files In Database?

Oct 3, 2012

In my project I am storing everything in database BLOB column.Everything includes images,documents,videos and any thing uploaded from form.

video should not be save in database.I want to know it is good idea to store everything in database BLOB column?

View 4 Replies View Related

Oracle - Recovering Database (All Files Lost)

Mar 2, 2011

I have a question in Recovering the database.

E.g. Backup has done yesterday and today evening all files are lost (control, redologs, archive, etc.)

We are in 24/7 environment then how we need to recover the database?

View 4 Replies View Related

Standby Data Files - Production Database?

Jul 24, 2012

: I noticed three data files on my standby show's they are corrupted. What will be the easy and fast way to sync them up from my production database?

View 1 Replies View Related

Moving Files On Physical Standby Database?

Oct 19, 2011

We're currently in a situation where the primary database server fs size does not match the standby database server fs size.

Standby database filesystem is almost 100% utilized, and we suggested to move some of the datafiles first to avoid threshold alerts and archive gaps.

Now, if we're gonna move datafiles on the physical standby, I believe the process would be stop managed redo apply -> shutdown standby -> OS move -> startup mount -> alter rename -> start managed redo apply. Is this correct? If not, how?

Also, would it have an effect if the controlfiles of primary and standby do not match because of the movement?

View 1 Replies View Related

Backup & Recovery :: How To Recover Database Having Only DBF And CTL Files

Oct 15, 2013

I have the following situation: a customer sent me a group of files, that he said to be a "backup" of an old database, that is no longer online (he doesn´t use our software anymore). However, he needs to recover the data in this database. The person at the company who generate these files doesn´t work there anymore, so we don´t have any of the following information:

- Database version, connection details, service names, user names neither tablespace names.

We were just told that these files were recorded in a DVD, and is que only source remaining.
The files he sent are the following:

ctrlcf_satp_01.ctl
ctrlcf_satp_02.ctl
ctrlcf_satp_03.ctl
daddf_satp_dad_01.dbf
[code]......

Is there a way to access this data? Or can I tell our costumer that your data is lost forever..

View 4 Replies View Related

SQL & PL/SQL :: Copy Some Archivelog Files Between 2 Database Server

Sep 27, 2011

I wanted to copy some archive log files between 2 DB Server.Steps:

1) Edited the Local and Remote DB's TNSNAMES file and modifyied like below.

bookstore =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.100.28)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BOOKSTORE)
)
)

2) Created a Source Directory --> DR1
3) Created a Target Directory --> DR2
4) Created a DB Link
CREATE DATABASE LINK LINK1 CONNECT TO <username of the Remote DB> IDENTIFIED BY <Password> USING '<Remote DB Name taken in the TNSFILE>.
5) In the Local Server I had written the below command.

create or replace procedure proc1 is
cursor c1 is select recid,substr(name,37) "ARCH_FILE" from v$archived_log;
var1 c1%rowtype;
begin
open c1;
fetch c1 into var1;
[code]...

It is working, but not coping the Files from Local To the Remote.

View 22 Replies View Related

RMAN :: How To Remove Database Files And Backup From ASM

Oct 19, 2012

Oracle Database 11.2.0.3
OEL 5.7

We have a host for restore purposes. We execute monthly or quarterly restore operations to verify that I am able to restore a subset of the data in the given amount of time or to other purposes. I have a automated script to Clone the Database, but to Clone Database we need remove the old database from ASM before start this operation. I want remove only Database files and keep the configuration (such as oratab/network/ocr and so on).

Question: There is a easy way to remove these files without connect on ASM or by using DBCA?

View 2 Replies View Related

Database Keeps Running Even After Deletion / Corruption Of Control Files

Jan 21, 2011

I was carrying out an experiment in order to crash the database and recover it.

The database was running, I moved the control file to another location and to my surprise the database was still running. I tried issuing checkpoint and transaction but it didn't affect database operations. I tried doing log switch. It completed successfully. According to my understanding and Oracle Certification books database was supposed to crash. But it didn't.

I tried this not only on RHEL, Windows XP but also in Solaris 5.10. The database version is Oracle 10.2.0.4 Standard Edition.

View 1 Replies View Related

SQL & PL/SQL :: Loading Documents / Images / Files Using LOB Into Oracle Database

Oct 5, 2010

code to put files such doc ,xls , jpg

into db using lob

i am developing application where user will be browsing the file from local pc which then will be loaded into oracle db not At OS DIRECTORY .

View 1 Replies View Related

Server Administration :: Load Database Files On Other Machine?

Dec 7, 2010

I am trying to upload a database backup on a machine. Since the structure of files is different from server, how can i start the database.

Do i need to create a new control file? If yes, how can i run the sql command "Alter database backup controlfile to trace" in nomount mode.

View 3 Replies View Related

SQL & PL/SQL :: Transfer Excel Files From Unix To Oracle Database?

Jun 6, 2013

I would like to ask you if you know which built-in can I use for transferring a excel file from our Unix box to a table in oracle database, right now we are using webutil_file_transfer.Client_To_DB_with_progress using forms developer, but I need to run as an automatic process uploading form unix into oracle directly without using forms.

View 22 Replies View Related

RMAN :: Change Database Name Control Files After Restore

Jul 12, 2012

I have restored database with the name DB to another database called DB01

it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible? I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01

what can I do next

ORA-01103: database name 'DB' in control file is not 'DB01'

View 5 Replies View Related

Application Express :: Importing CSV Files To Database Backend

Dec 15, 2012

There is a report that is generated everyday in the .csv file format that i would want to load into the database. I want to completely automate this process. I don't want to use the load function available in APEX. I use APEX 3.2 Version.

What i mean by automation is that i will create the CSV file and automatically move to a location from which APEX can access the data. I would then write a procedure to fetch the content directly from CSV file and write to the database. What i need is the location from which APEX can access data directly ?

View 1 Replies View Related

Data Guard :: How To Transfer Redo Log Files To Standby Database

May 29, 2010

How to transfer redo log files to standby database..

View 1 Replies View Related

Data Guard :: Transfer Archived Log Files To Standby Database

Oct 8, 2011

1> Does dataguard in 10g use ftp/rsh to transfer archived log files to standby database or some other protocol?

2> In my primary database, archives are getting generated normally, there is no error in alert log file. But archives are not getting transferred to standby database. I am able to connect through sys user from primary server to standby database & vice versa.

Also, tnsping is working fine.

All was working fine till 2 days back & no parameter has been changed from database side. I am not able to transfer the file manually through FTP to standby server. Does it is the problem? Or dataguard doesnt use FTP protocol to transfer the files?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved