Can SQL Loader load files on a remote server?

Advertisement

Hello,
I normally use SQL loader on my PC to load an 8i database located on an NT server in another state. The input file is rather large and takes several hours to load-- even with all the contraints, etc. disabled. I assume this due mostly to all the network hops between my PC and the server. I now have an FTP that can place the input file on our Oracle DB server itself. It seems to make sense that if the files were located on the server, it would load much faster. My question is: is it possible to create a sql loader process to load files located on the remote Oracle server that I can initiate or control from my PC?
Thanks in advance for any help.
Jeff

Advertisement

Windows Terminal Services will allow you to interact with the server where you are loading the data. You could FTP the file to the remote server, start a Terminal Services session, and type or run your parameter file at a command prompt. One thing to be aware of is setting the ORACLE_SID environment variable. When you set ORACLE_SID and try to connect to the database withconnect / as sysdbayou will get the following errorERROR: ORA-12560: TNS:protocol adapter errorbut if you connect withconnect /@<connect_string> as sysdbathe connection works perfect. Don't really know the details on why it does this but just a issue to look out for.

November 30, -0001

Can SQL Loader load files on a remote server?

Hello, I normally use SQL loader on my PC to load an 8i database located on an NT server in another state. The input file is rather large and takes several hours to load-- even with all the contraints, etc. disabled. I assume this due mostly to all t

Why can I not open files saved on a server?

Why can I not open files saved on a server?I think I figured it out.  I set the compatibility mode to Windows Server 2008 (which is the OS on the server we are using) and it opened just fine.  Whoop Whoop.  Thanks for your help. LisaRead other 8 answ

MS Project Professional 2007 resource loaded .mpp file published to EPM server but resources can't see their tasks in PWA

Hi all: I'm using MS Project Professional 2007 and I created the schedule as an .mpp file and assigned resources before I loaded the schedule to the EPM server. I created the resource names consistently with the names in the Enterprise resource pool

Loading flat files located on a server using the Control Center piece ofOWB

Loading flat files from a server with OWB I am successful loading files with OWB, as long as they resided on my workstation in the C:\ drive. I copied the files to a Linux server into directories owned by Oracle/oinstall, permissions on the directori

Robohelp 7 App is really slow in deploying files to the remote server - Why?

Hi, I am totally new to RoboHelp. So Please forgive my ignorance! The Robohelp we have was developed by somebody who is not with our company anymore. I think he used Robohelp 5 to develop our Policies and Procedures. The files are deployed on one of

Read File using File adapter from remote server

I need put poll on remote directory for files. Can some one tell where to put the remote connection details? Thanks KKSorry dumb question!!!! We can use GetFile operation in FTP adapter..... Thanks KKRead other 2 answers

Is it faster to download files from a remote server or file sharing with Back To My Mac?

I am trying to send somebody a 6GB file using Back To My Mac. I had them set up my Apple ID in iCloud in System Preferences on their Mac and check the box for Back to My Mac. Went into Sharing preferences to check the boxes for File Sharing and Scree

Can't copy large files to E4200 Media Server

I've rolled back my E4200 router to the old firmware 1.0.0.1, then set up a media server. It generally works (e.g. it streams pre-existing media files to other devices). I can copy to this external drive small (say, < 1 MB) files.  The drive has

Can't write large files to my WebDAV server

Hi, yesterday I set up a WebDAV directory on my mini using Apache 2.0.56 with digest authentication. Everything works fine when I connect from home, however, when I tried to access it from work I got some very strange reactions. Connection worked out

Lost my files, can I dl from remote server?

So, I'm stupid and arrogant and didn't back up my computer and of course my hard drive failed. I'm also clueless to most of this html web design stuff but do it myself anyway cause that's just how I am. That and being poor. Anyway, is there a way to

How do I copy and paste files from a windows remote server to my mac?

How can i copy and paste files from a remote server (windows) to my mac? i have installed cord to connect to the server but now i can´t cpy the files to my mac!Hi Sara.  Tanks for responding.  If I cannot figure this out (I  was up until 2am last nig

Help! Downloading a file from remote Server

I am currently doing a program for downloading a specified file from the remote server i.e from any website. If the downloading process stops in between due to some problem in the internet connection, then my program needs to start the downloading th

Can't see dependant files on server

I took over a prject from another designer and am trying to download the websites files/folders from the server using CS4's site manager. I can see the index.htm file on the remote server and several other folders that appear either private or unrela

File upload to sftp server using apex

We have an SFTP server on Linux and we want to provide users with web-based interface (Oracle APEX has been chosen for that purpose) so they can upload their flat files to our sftp server via secure transmission. is it possible to implement on APEX?

Help! Save to remote server has broken links to all images

Okay, I (now) know this was a stupid thing to do - but surely there must be an easy way to rectify it...!? I usually 'PUT' the html files to the remote server, once they have been saved locally. But I keep getting frustrated with the uploading of all

Create a Document with an original file stored on application server

Hello, I start with document managment system : i am able to create new document (CV01N) manually, add a local file and check-in this file. Now we need to store file which are stored on the SAP Application Server. Firstly, in the GUI of transaction C

Sql loader issue(How to specify a file that exists on remote server)

In sqlldr infile parameter I'd like to give a data file that exists on remote server.How can I specify???Please help me in the syntax. Any help would be greatly appreciated. Edited by: 792353 on Sep 24, 2010 7:22 AMsqlldr can accept any path that is

SQL Loader Control file help!!!

Hi All, I was in the process of writing a control file for sql loader for an activity i am performing and would appreciate inputs from you all. I have a table patient containing 44 columns, i have a column 'SEC_LANG_NAME' in which i have to insert da

Create sql loader data file dynamically

Hi, I want a sample program/approach which is used to create a sql loader data file. The program will read table name as i/p and will use select stmt will column list derived from user_tab_columns from data dictionary assuming multiple clob columns i

SQL Server 2012 Express - Could not load the file or assembly 'Microsoft.VisualStudio.OLE.Interop

Windows 7 Home Premium, SP1 64-bit I just installed SQL Server 2012 express - Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search), file name -  SQLEXPRADV_x64_ENU. Opening SQL Server