How To Run All Scripts Present In A Folder
Dec 22, 2011
My 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.
View 3 Replies
ADVERTISEMENT
Jul 4, 2011
I 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?
View 39 Replies
View Related
Apr 11, 2013
I 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?
View 3 Replies
View Related
Oct 4, 2013
We 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 Related
Mar 10, 2011
I 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.
View 3 Replies
View Related
Nov 16, 2012
I 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.
View 8 Replies
View Related
Apr 29, 2013
I 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 '
View 3 Replies
View Related
Jun 2, 2011
I am trying to get only those values which are not present in the column. I have tried but i think that i am wrong in logic.
SELECT dummy
FROM DUAL
WHERE dummy IN
('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12',
'13')
AND NOT EXISTS (
SELECT pay_list_serial
FROM per_requests_master
WHERE request_status IN ('4', '5')
AND pay_list_no = :list_no)
View 12 Replies
View Related
Feb 9, 2010
I 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
Oct 12, 2013
I 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'.
View 17 Replies
View Related
Jun 11, 2012
I 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
View Related
Oct 12, 2013
How to create folder using oracle form. I used HOST command but its not working.
HOST ('md C:Emp_Photo2013');
View 5 Replies
View Related
Mar 5, 2010
I want to ask if we could create a sub folder using the SPOOL command. I tried the following but it gave "Cannot create Spool file" error.
SPOOL C:TESTABCABC.sql
where TEST is already present in the C drive whereas I want SPOOL command to create a sub-directory named 'ABC' and then create the spool file 'ABC.sql' isnside it.
Is this possible ? My OS version is MS XP.
View 4 Replies
View Related
Jun 12, 2012
I want read 500 GPG image files from a folder ( by A Button in Form ) and move images into a table with a image column (create new records with images) .
View 3 Replies
View Related
Oct 5, 2010
Where should one store pictures in database or read it straight from a folder stored in hard disk and why (performance talking)?
View 4 Replies
View Related
Jan 20, 2011
when i install oraclexe on my system..when i want to connect the oraclexe then it give error
D:oraclexeapporacleproduct10.2.0serverBIN>net start OracleXETNSListener 'net' is not recognized as an internal or external command, operable program or batch file.
D:oraclexeapporacleproduct10.2.0serverBIN>net start OracleServiceXE 'net' is not recognized as an internal or external command, operable program or batch file.
D:oraclexeapporacleproduct10.2.0serverBIN>c
when i check this path D:oraclexeoradataXE then i check datafiles not generated in this folder
View 2 Replies
View Related
Nov 27, 2012
How we can mask a column value present in the production which is very sesitive like bank a/c no,Credit card nos etc while replicating to the test/development envirnoments in PL/SQL.Things that need to be considered is referential integrity,data types,length of the column and performace while execuing the code.
View 2 Replies
View Related
Jun 8, 2010
I need to find all the tables present in DB or Schema.
View 3 Replies
View Related
Apr 27, 2010
I have two schema SCHEMA_A and SCHEMA_B in the same Database.
I want to execute a procedure UPDATE_CONTACT() which is present in SCHEMA_A from SCHEMA_B.
let me know whether the following SQL is correct:
BEGIN
SCHEM_A.UPDATE_CONTACT();
END;
View 4 Replies
View Related
Jan 24, 2012
Opening 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 Related
Aug 3, 2010
I have got oracle 11g release 1, I need recomendation, how can I delete safely content from the folder C:oraclediag dbmsinstancenameinstancenameincident?
can i delete files manually which are not useful?
View 4 Replies
View Related
Mar 16, 2012
Would like to know, how to find the size of individual folder in ASM 10g !
Also I am not able to find the PATH/name of the raw devices in ASM 10g !
View 3 Replies
View Related
Nov 28, 2010
I have table called test script for table is given below
create table TEST
(
col1 Number
);
[Code]...
For these values Query is not returning values(3 and 4). So i want generic query to get this result. I am working on it but not able to generate proper query.
View 2 Replies
View Related
Jun 23, 2013
In dept table there is deptno=10,20,30,40
in emp table there is deptno=10,20,30
i want to find the deptno which present in dept table but not
present in emp table.
View 4 Replies
View Related
Sep 20, 2012
I used search option but i didn`t find answer to my question. My problem is with importing files into table( 2 columns > 1 number, 2 clob ). I can`t use SQL Loader becouse i need to load 30.000 tar.gz files from 1 folder, IMPORT option in SQL developer didn`t work too.
View 1 Replies
View Related
Mar 3, 2012
I 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 Related
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
View 1 Replies
View Related
Jun 24, 2013
In my Folder Form i have 6 Total Fields(SUM) , when i press anyone of these Total Filed, to move Right Or Left i got an error like this "frm-40733 pl/sql built-in set_group_char_cell failed."
View 6 Replies
View Related
Apr 29, 2010
i want to produce a function who return XmlType element if she checks that a parameter (that i passed to here is contained in a row in a defined table)
for example
create table sec_form(
form_code VARCHAR2(8)
, sec_code VARCHAR2(5)
) ;
insert into sec_form values ('CSA','section1');
insert into sec_form values ('CSA','section2');
insert into sec_form values ('CSA','section3');
then i got my function
create or replace function checkIfSectionEnabled (elem XmlType,name_section varchar2)
return XmlType
is v XmlType;
CURSOR myCursor IS select * from sec_form where form_code = 'CSA';
begin
open myCursor;
loop
[code]....
now i'm gonna call the function (elem XmlType,name_section varchar2) and pass here "section1" for example ; and she must return me my xmltype element if she find "section1" finds section1 present;
when i try t compile i got:
Error(18,13): PL/SQL: Statement ignored
Error(18,26): PLS-00225: subprogram or cursor 'MYCURSOR' reference is out of scope
View 3 Replies
View Related
Mar 17, 2010
I have a form reading record information from a flat file and inserting data into a number of varied tables. At the end of file (last line read) the form issues a commit to make all inserts/updates permanent.
There is a record that disappears in particular and this everytime I re-run the test. I mean than in Debug mode, I find it in the right table everytime I query that table until the moment the commit is issued in the code - which is definitely the opposite of what should happen. I understand that for some reason a rollback happens for that record (others are ok after the commit) but my point is that if for some constraint reasons, the record did not qualify, an error should have popped up right from the Insert that added that record, right? Then How comes I find it in the table up until the moment of the commit ?? ...is the deferrable constraint property a clue for digging further?
View 3 Replies
View Related