SQL & PL/SQL :: Change External Directory From Server To Local Machine Path

Nov 15, 2012

how change the default directory path from server to our local system directory in external table while loading the data from csv file to table actually my default directory 'abc'(installed oracle server directory) in external tables , now i want to change that default directory to my local(c:Sm(not installed oracle s/w)).

View 1 Replies


ADVERTISEMENT

Open Excel File From Oracle Directory On Local Machine

May 31, 2013

I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .

View 1 Replies View Related

SQL & PL/SQL :: Downloading A File From Server To Local Machine?

Jul 3, 2012

i am working on Database 11g. I Need to download file to local after the file is created in the database directory using UTL_FILE . i am able to generate the file but not aware how to copy or download the file to local using PL/SQL . i have done the same in forms using webutil pll.

View 2 Replies View Related

PL/SQL :: Spooling Data From Remote Server To Local Machine

Feb 6, 2013

I need to spool data from a remote server using putty(sqlplus) to a local machine. There are credentials i need to give before accessing the remote databases and i am able to do it..i tired with the below query but the spool file(csv or txt) is not able to create on local machine.

set colsep ,
set pagesize 120
set trimspool on
set headsep off
set linesize 1000
set numw

spool D: estmyfile.csv
select table_name, tablespace_name from all_tables;
spool off

View 2 Replies View Related

Forms :: Export Table Data Into Excel Sheet On Local Machine Or Server Itself?

Oct 9, 2013

i am accessing a form from server through URL using oracle application server FORMS & REPORT services. and i am trying to export table data into excel sheet on my local machine or the server itself.

i am using the following code on WHEN BUTTON PRESSED

PROCEDURE REFERENCELIST IS
BEGIN
DECLARE
AppID PLS_INTEGER;
ConvID PLS_INTEGER;
RCount Number := 0;
CURSOR c1 IS SELECT MATID, MATCODE ,DESCRIPTION , PARTNO FROM REFERENCETABLE;
PROCEDURE INSERTROW (invalue VARCHAR2, incol NUMBER) IS

[code]....

this does not give any error and any result as well. the above code very much fine while i run it on my local laptop.

View 1 Replies View Related

SQL & PL/SQL :: Retrieve The Path Of A Directory

Oct 27, 2011

I create a directory using this:

CREATE DIRECTORY xml_data AS 'c:\mytest';

How can I retrieve the 'C:mytest' in a select statement?

View 5 Replies View Related

SQL & PL/SQL :: ORA-29280 / Invalid Directory Path

May 13, 2012

I started working on utl_files. When i Am working on this topic I struck with an error: Quote:ORA-29280: invalid directory path. Below are the steps I followed to work on utl_files,

STEP1: connect sys as sysdba

STEP2: @$ORACLE_HOME/rdbms/admin/utlfile.sql

STEP3: create or replace directory utl_data_files as '/home/oracle/siva/data/'; --(the directory path is already exists in the OS)

STEP4: below is the code

DECLARE
out_file UTL_FILE.file_type;
linebuf varchar2(1999);
directory_name varchar2(100):='utl_data_files';
BEGIN
out_file:=UTL_FILE.fopen(directory_name,'emp.dat','W');
for emp_cur in (SELECT * FROM scott.EMP)

[code].....

STEP5: then it's giving the below result/error info

Quote:

SQL ERRORCODE IS:-29280
SQL ERROR MSG IS:ORA-29280: invalid directory path

PL/SQL procedure successfully completed.

View 2 Replies View Related

PL/SQL :: ORA-29280 / Invalid Directory Path

Sep 9, 2013

When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.

error : ORA-29280: invalid directory path
ORA-06512: at line 34

DECLARE
l_out_file  UTL_FILE.file_type;
g_convert_crlf  BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
  l_buffer    VARCHAR2(32767);
  l_amount    BINARY_INTEGER := 32767;
  l_pos       INTEGER := 1;

[code].....

View 1 Replies View Related

PL/SQL :: Loading Data From Local Directory

Jan 22, 2013

I have a requirement like, I received .dat files and placed in my local directory and there is a process/method where this data which is there in .dat file will insert into my oracle external tables?Any link of the example with clear steps?

View 9 Replies View Related

PL/SQL :: Error / ORA-29280 / Invalid Directory Path

Apr 9, 2013

When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.

error : ORA-29280: invalid directory path
ORA-06512: at line 34

DECLARE
l_out_file  UTL_FILE.file_type;
g_convert_crlf  BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
  l_buffer    VARCHAR2(32767);
  l_amount    BINARY_INTEGER := 32767;

[code]....

View 11 Replies View Related

PL/SQL :: Utl_file  ORA-29280 - Invalid Directory Path

Aug 26, 2012

I am testing to find out that by using utl_file, if I finish reading all the entries in the file, then I encounter no_data_found, just want to make sure I get no data found when all entries in the file are read

SQL> create or replace directory my_docs as 'c:photos';

create or replace procedure myproc is

v_line VARCHAR2(2000); -- Data line read from input file
v_file UTL_FILE.FILE_TYPE; -- Data file handle
v_dir VARCHAR2(250) := 'my_docs'; -- Directory containing the data file

[Code]....

/so I execute this procedure and I get

ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "MYPROC", line 12
ORA-06512: at line 2

View 8 Replies View Related

SQL & PL/SQL :: Read File On Local Machine?

Jun 27, 2012

From a script how I can read a local file (where I have the sql client)?

I have an Oracle database on a server, and I connect from another machine with SQL Developer.I want to read a text file on my local machine ( where I run my script) to use the data in the script.I never want to read or write on the server.

Reading on internet i read about UTF_FILE package But what is not clear to me is, this is on the server or client ?Also some people says UTF_FILE can work both on client side and server side.Also I read about package text_io, but I think it is only for forms.

View 5 Replies View Related

Forms :: How To Get File Directory Path Dynamically In The Report

Sep 6, 2013

I want to get file directory path dynamically with out using directory in database or not hard code like below

the purpose is i need to check image in the path directory if not found i unable to generate report, is there any possible to get dynamically

function CF_URLFormula return Char is
v_handle utl_file.file_type;
v_file_dir VARCHAR2(60) := '/u002/app/applmgr/temp/';
begin
v_handle := utl_file.fopen(v_file_dir, :photo_name, 'R');
utl_file.fclose(v_handle);
RETURN v_file_dir||:photo_name;
exception
when others then
srw.message(100,SQLERRM);
return null;
end;

View 1 Replies View Related

Forms :: How To Save File On Local Machine

May 10, 2010

I have a requirement to :

1) at the click of button, some data will be written to XML file and after writting to file, it should get saved to some location on local machine(c: emp), without asking user, where to save.

How to do this in oracle form?

Also is it possible to read file from local machine?

View 7 Replies View Related

Backup & Recovery :: AWR To Be Created On Local Machine

Feb 1, 2012

Q: I have a script, which is generating the AWR report on the server side.

We have 5 servers. All the server's AWR report to be copied (or To be created Directly) on the local machine.

CREATE OR REPLACE PROCEDURE CreateAwrReports(directory varchar2)
as
v_Instance_number v$instance.instance_number%TYPE;
v_Instance_name v$instance.instance_name%TYPE;
v_dbid V$database.dbid%TYPE;
v_file UTL_FILE.file_type;
[code].......

View 4 Replies View Related

SQL & PL/SQL :: Read All Files In Directory On Client's Machine

May 30, 2012

I want to read all the files present in a directory of client's machine.

However I have achieved this by creating java class in database but the problem is it accesses the directory of machine on which database is installed not the client's machine.

I have oracle client and I tried to access local directory of client's machine to read all the files in that directory but it didn't work.

However, I achieved this by creating one java class for ex. test.class and I run it locally through command prompt but I want to achieve it using Pl-sql.

View 8 Replies View Related

Application Express :: Automatic Save File From Apex To User Local Directory

Jun 13, 2012

how can save pdf file from apex to user local directory on button click?

View 2 Replies View Related

Export/Import/SQL Loader :: External Tables Loading Multiple Files From Directory One By One

Oct 4, 2013

the following situation, I have a directory named /dat/global/stock/  inside this i will get files named differently for example below.abcdef.112dfgrt.2......

 Here i want to load this file one by one into the external tables and generate one more file based on some enrichment.

Step 1. Have to take first file and to load into the ext table.
Step 2. Enrichment
Step 3.File generation. 

Now here i am facing a problem that in that particular directory i usually get 1000 files so i need to get file one by one and to put in one more directory. how can i get file one by one and generate file by using oracle loader 

View 4 Replies View Related

Export/Import/SQL Loader :: Setting For External Table - Create File In Directory DIR-1?

Nov 20, 2012

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

I am new in external table so i have tried following cmd.

create directory dir_1 as 'E:ora_dirt' ;
grant read, write on directory dir_1 to HR;
select * from all_directories;
create table emp_ext
(emp_id number,
emp_name varchar2(30)

[code]...

since I am not able to see DIR_1 in E: drive due to which i havnt created  'emp.dat' file and on executing select on external table i m geting expected error *"ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04043: table column not found in external source: EMP_ID"*

how to create that file in directory "DIR_1" .

View 2 Replies View Related

How To Change Datafile Path

May 13, 2013

I need to change data file path, and i got some document also but one thing confusing me, we need to offline the Tablespace, so my concern is all the table space like system, sys, user, temp etc. need to offline and then alter the database?

View 9 Replies View Related

Import Oracle 9.2 Exp To 11.2 - How To Change Path

Dec 10, 2012

The source server (9.2) is /oracle/data/xxx the destination will be /u02/oradata/xxx how do I get the imp to change the paths.

I know you can't do db_file_name_convert, as that only works in dataguard with rman, and it looks like you can only set compatible down to 10.2, it's a very small DB, (5Mb) but it's a live license server DB, I need it intact.

I tried a straight import, but that just barfed with "IMP-00015: following statement failed because the object already exists:" on every statement.

EDIT: it's lying, the /oracle path doesn't exist, just FYI.

View 8 Replies View Related

How To Change Oracle TNS Listener Path

Oct 29, 2010

how to change this path:

F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR

to this path:

d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR

in the service ?

View 2 Replies View Related

Best Way To Change Language Of Windows Oracle Client Machine Edit Registry

Jun 29, 2012

We have installed oracle client on Windows machine and despite selecting language as English

when look in registry shows NLS_LANG as

AMERICAN_AMERICA.WE8MSWIN1252.

What is the best way to change language of Windows oracle client machine edit registry.

View 2 Replies View Related

Real Application Clusters :: Listener Status Showing Local Virtual IP / But Not Local IP

Jan 19, 2013

SNRCTL> stat LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date 19-JAN-2013 00:50:10
Uptime 0 days 0 hr. 29 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
[code]....

In every oracle documentation for e.g:11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1] we found the local listener status showing both local-ip and vip. Why is not showing in our case?

View 8 Replies View Related

Server Utilities :: How To Access Local File Residing At Client From DB Server

Nov 23, 2011

I have a requirement to read flat text file(around 15000 lines) residing at a client location from DB server and write into a table in One cell.

I tried UTL_FILE and DBMS_LOB but, i am not able to access client location to read the file as it reads path from Oracle Directory.

eg.
my client path is 198.168.1.1 and my DB server is in unix say 192.168.1.10.
file location is: \192.168.1.1shareabc.txt
So I created One Oracle directory as MY_DIR having DIRECTORY_PATH as '\192.168.1.1share'.
But both UTL_FILE and DBMS_LOB is not able to access the file.

Error Message:
-------------
Unable to process CLOB -22288 ~ ORA-22288: file or LOB operation FILEOPEN
failed
No such file or directory

Few Details for reference:
-------------------------
File Location: \192.168.1.1shareabc.txt
Unix DB Server location: 192.168.1.10
Table : Test (filename varchar2(30), Content CLOB)
Oracle Dir: MYDIR
Directory_Path: \192.168.1.1share

View 7 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Server Administration :: SHUTDOWN And STARTUP DB Server From Client Machine?

Sep 21, 2010

I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.

Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.

Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it

may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.

View 12 Replies View Related

Server Utilities :: Direct Path Loading

Apr 19, 2010

I have a small confusion in direct path loading. Will direct path load ever use memory (SGA)? If yes, why it is not generating redo? If no, can we write into a block at file system level directly.

View 1 Replies View Related

Server Administration :: Ora-03114 Using Local Database?

Jan 22, 2010

i m using local database for attendance system. attendance machine is on domain. when network connection failed, form gives error ORA-03114.

View 1 Replies View Related







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