SQL & PL/SQL :: How To Add Oracle Data File To App_Data Folder
Jun 11, 2012I am using Oracle database with visual studio 2010,how to add all my local database tables to App_Data folder in a .NET project?
View -1 Replies
ADVERTISEMENT
SQL & PL/SQL :: Writing Data To A Network Shared Folder / ORA-29283 / Invalid File Operation
Jul 13, 2010I am trying to write data to a network shared folder. When I write to a local file it works perfectly. Below is my procedure.
CREATE OR REPLACE procedure nbpsbp_file as
type r_cursor is ref cursor;
refr r_cursor;
tab_name varchar2(20):= null;
tab_name1 varchar2(20) := null;
tab_name2 varchar2(20) := null;
[code]....
When I execute the above procedure, it gives me the following error
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
ORA-06512: at "NBPSBP_FILE", line 36
ORA-06512: at line 1
I have also set the parameter utl_file_dir = '\10.16.10.225 emp' When I set the utl_file_sir to a local folder, for example, c: emp, and use the same path in UTL_FILE.FOPEN, then it works fine and writes the desired output to text file. But when I give it a network address, it raises the above error.
SQL & PL/SQL :: Get File Name XML In Folder
Jul 4, 2011I have problem follow:
- I hava folder obitan files .xml : C: emp
+ File .xml as: emp.xml, dept-110720.xml, etc...
- Now, i would get file name .xml in folder C: emp. How do i do?
SQL & PL/SQL :: Fetch File Path From A Folder
Oct 4, 2013We upload a file on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible.
View 12 Replies View RelatedData Guard :: Changing Redo Log Folder On Primary Database
Mar 3, 2012I want to replace one redo log on the primary database. actually this redo log is on G:oracleoradata; I want to move it on F:oracleoradata. How to do that cause the same redo log is also on standby database?
View 3 Replies View RelatedInstallation :: Lib32 Folder In Oracle 11g R2
Nov 16, 2012I have Oracle 11g R2 64bit installed on Solaris 5.10 machine. I found that in Oracle 11g R2 there is no lib32 folder which contains the 32bit libraries. But application only works with 32bit libraries.
How and where do I get the 32 bit libraries for Oracle 11gR2.
Forms :: How To Copy Image From One Folder To Another Using Oracle 6i
Oct 12, 2013I want to copy image/pdf/doc file from one folder to another folder. For that I use following code but its not working.
DECLARE
v_path VARCHAR2 := 'C:ESMIMAGE';
BEGIN
HOST ('COPY '||v_path||'admin.jpg '||v_path||'BE2013', NO_SCREEN);
END;
I want to copy admin image from 'C:ESMIMAGE' to 'C:ESMIMAGEBE2013'.
Forms :: How To Create Folder Dynamically Using Oracle 6i
Oct 12, 2013How to create folder using oracle form. I used HOST command but its not working.
HOST ('md C:Emp_Photo2013');
Backup & Recovery :: Restore Using Copied Oracle Folder
Jan 24, 2012Opening the database with manually copied oracle data folders and files. Due to my server crashed we were forced to format the system. In that my friend by mistake copied the oracle folder (All data files, redo log files) manually instead of taking a backup in a procedural manner. Now we need to restore all the data. Would it be possible to restore the data with copied data file. If so how?
View 10 Replies View RelatedJDeveloper, Java & XML :: Filling Folder Oracle Jar Cache With Some Files
May 16, 2011 what is the reason for filling the folder "Oracle Jar Cache" with some files? Why should we clear the cache ? My clients are also facing same issue. When they use the application continuously(in forms9i) after some time, application getting hanged. When we follow these steps its working fine:
- close all IE
- and clear the cache ,
- then re-start machine
Unable To Load Data In Oracle 11g From XLS File?
Sep 6, 2011CASE 1:
when i tried to load the data i got the below error,
Error starting at line 2 in command:
INSERT INTO RECON_MATCHED_DETAILS (RECON_MATCHED_DETAIL_OID, RECON_ID, STATEMENT_DATE, EXECUTION_DATE, TRANSACTION_NUMBER, TRANSACTION_DATE, TRADE_ID, TRANSACTION_TYPE, LINK_ID, ITEM_TYPE, ASSET_CODE, ISIN, BUYSELL_INDICATOR, SETTLEMENT_DATE, CURRENCY, QUANTITY, VALUE,
[code]...
CASE 2:
i tried to load the data in oracle 11g but i'm unable to load the data,and for testing i tried with a single row of data.but surprisingly the table filled with (null)s
SQL & PL/SQL :: Load Data From Oracle To Text File?
Jun 18, 2013I want to load data from oracle table to flat file(csv/text file). Is there SQL query to do this?
View 14 Replies View RelatedInsert Data From DMP File To Oracle 11g Using SQL Developer 2.1.1.64?
Mar 22, 2011i backup my database using PL/SQL developer and made *.dmp file
how to insert data from *.dmp file to oracle 11g using Oracle SQL Developer 2.1.1.64
and how to make *.dmp file from sql*plus ?
PL/SQL :: How To Read CSV File And Insert Data Into Oracle Table
Feb 6, 2013I have a Clob file as a in parameter in my PROC. . File is comma separated.need procedure that would parse this CLOB variable and populate in oracle table .
View 6 Replies View RelatedSQL & PL/SQL :: Procedure To Load Data In Oracle Table Into Excel File
Dec 29, 2010send me the procedure for loading the data in an oracle table into an excel file.
View 5 Replies View RelatedSQL & PL/SQL :: Oracle Stored Procedure To Load Flat File Data
Oct 24, 2013I need to create an Oracle Stored Procedure to read a Flat file(pipe delimited) and load the data into an Oracle table. I believe the file should be located in any of the path as logged in dba_directories table or it can be anywhere on the local client machine?
View 14 Replies View RelatedServer Utilities :: Unload Data From Oracle To Text File?
Jun 14, 2012We have around 30 million rows in a table which we are extracting through UTIL_FILE and sending this file to somewhere to other systems.
But this extraction taking too much time.
Is there any way out to optimize this process or any new stuff.
PL/SQL :: Transferring Data From Oracle Table To A File On A Windows Server
Nov 12, 2013I have an oracle DB version 11.2 running on oracle enterprise linux 5.9. How to transfer data from the oracle DB to a flat file on a windows server. What i have done so far is to use utl_file to create a csv file on the oracle server and am now attempting to transfer this file.
I was going to use scp or rcp but am unable to get this to work(was looking at filezilla). Another option i can use is ftp as i have a UNIX script which i can run to do this. All this is done through an oracle package which is run hourly through dbms_scheduler. I have been using sp_host_command to run unix commands directly from pl/sql so can use this to run a unix script for last resort if i cant find an easier way to automate this.
SQL & PL/SQL :: Exporting Oracle Data Into Excel File With Auto Column Size
Nov 7, 2007I want to export the oracle data into an excel sheet. I have written the code by using UTL_FILE package. but i am getting the output as shown in the screen shot(without formatting the column size as the width of the data it has). But I want the output column width to be set according to the size of the data automatically.
View 5 Replies View RelatedClient Tools :: Export Data From Oracle Database To Excel File?
Aug 21, 2012I am using SQLTools 1.5 for writing Oracle SQL scripts.
I have to import data from excel file to oracle database. How can I do it?
Also how can I export data from Oracle database to Excel file?
Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File
Aug 24, 2012I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies View RelatedServer Utilities :: Import Constraints Only From Dump File Using Oracle Data Pump?
Nov 16, 2011How to import constraints only from a dump file using Oracle data pump.
View 1 Replies View RelatedServer Utilities :: Import A Dump File Using Impdp Data Pump Utility On Oracle 10g
Feb 19, 2012Is it possible to import a dump file using impdp data pump utility on oracle 10g where the export dump was taken using traditional exp utility and vice versa.
View 1 Replies View RelatedServer Administration :: ORA-01111 / Name For Data File 636 Is Unknown - Rename To Correct File
Nov 3, 2012i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i received errors
SQL> alter tablespace APPLSYSD READ ONLY;
alter tablespace APPLSYSD READ ONLY
*
ERROR at line 1:
ORA-01230: cannot make read only - file 636 is offline
ORA-01111: name for data file 636 is unknown - rename to correct file
ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636'
i have not this file on the OS
SQL & PL/SQL :: Combining Rows In Data File Based On Values In Control File?
Aug 29, 2013I have to load data file into a table. And the requirement is as below:
Input Data:
1234|20130815|20130822|This is a test, this is the the part
3456|20130823|20130809|This is a test
3456|20130823|20130809|This is a test
3456|20130823|20130809|This is a test
3456|20130823|20130809|Siva 1234
The data should be inserted only in two rows as below:
When Value in first 3 fields is same, 4th field should be appended to the existing value in table.
1234|20130815|20130822|This is a test, this is the the part
3456|20130823|20130809|This is a testThis is a testThis is a testSiva 1234
How To Run All Scripts Present In A Folder
Dec 22, 2011My directory has around 100 sql files to run via sqlplus. For test purpose, I took only 2.I tried following code in the batch file to process those 2 files:
for /f %%a IN ('dir /b *.sql') do ( sqlplus -S sys/ankit@orcl2 as sysdba @%%a )But as the following output shows, only 1 was processed :
C:\Documents and Settings\Administrator\Desktop>cd C:\temp\Copy_WMGIS_DWH\6DBlinks\
C:\temp\Copy_WMGIS_DWH\6DBlinks>for /F %a IN ('dir /b *.sql') do (sqlplus -S sys/ankit@orcl2 as sysdba @%a )
C:\temp\Copy_WMGIS_DWH\6DBlinks>(sqlplus -S sys/ankit@orcl2 as sysdba @PUBLIC.MAXIMO.sql )
Database link dropped.
Database link created.
It stops after this. But when I press ctrl+C , it asks me if to stop (Y/N). I choose 'N', it runs second file as shown below:
Terminate batch job (Y/N)? n
C:\temp\Copy_WMGIS_DWH\6DBlinks>(sqlplus -S sys/ankit@orcl2 as sysdba @PUBLIC.VENTYX.sql )
Database link dropped.
Database link created.
It should run second one itself, not via user interaction.
RMAN :: Restore Asm To Same Folder?
Apr 11, 2013I am in process of restoring database for a standby.When I am restoring datafiles, it says it is restoring to an original location (same as primary database).
restoring datafile 00242 to +MYDB_DATADG/mydb/datafile/data_05.474.805989155 but when I checked with asmcmd utility, it is actually another path/filename. Only same thing is the diskgroup name.
So the file would be
-> +MYDB_DATADG/mydb_stby/datafile/data_05.281.812429111
How do I force rman to restore to the same exact location as my primary database?
Backup & Recovery :: Archived Log In Only One Folder
Mar 10, 2011I have recently installed a oracle 11g r2 standard edition in aix 6.1.database is on archive log but archived log is generated in daily different folder named after date on system.
i want to generate all archive log in only one folder.
Forms :: Fmx Files Into Separate Folder
Apr 29, 2013I have some .fmb files in 'F: ask" " ' location.and my question is can i store the .Fmx files in other location like 'D:" " '
that is if i create a .fmx file for the 'F: ask**.fmb'. i want That .fmx file will store into other location i.e 'D '
Forms :: How To Browse Specific Folder Or Drive In 6i
Feb 9, 2010I want to open any drive or specific folder in forms 6i in when button press trigger like we open any drive and folder in my computer or folder in windows
View 3 Replies View Related