i have this table structure create table file (id number, media_file blob).how i upload pdf or jpg files from this table to computer for example to C:myfiles
View 3 RepliesUsing Apex 3.2 version , Need to Upload .CSV Files to the Table (T_UPLOAD),
View 11 Replies View Relatedis it possible to upload very large files in oracle's tables. For example 1-2 gigabyte video file or even more. In other words is it possible to use oracle as file server to upload very large files and store them?
View 2 Replies View RelatedI have used webutil_file_transfer.Client_To_AS_with_progress to upload files from client to Application Server using Forms 10g.However, now i want to save file in database and not upload to database as blob.I mean I want to save the file from client TO a folder available in the database server.I was wondering, there is no documentation available on WEBUTIL.
View 6 Replies View RelatedI have a requirement to import text files which are generated from 3d modelling software xsteel where it records all geometric information and i want to import this information into oracle table.
CREATE TABLE dstv_head ( wo_no VARCHAR2(12),struct VARCHAR2(12),rev_no NUMBER,
mark VARCHAR2(12),pos VARCHAR2(12),grade VARCHAR2(12),qty NUMBER,PROFILE VARCHAR2(24),TYPE VARCHAR2(12),
len NUMBER,width_web NUMBER,width_bottom NUMBER,flange_thk NUMBER,web_thk NUMBER,radius NUMBER,kgm NUMBER,
kgm1 NUMBER,kgm2 NUMBER,bevel_plus NUMBER,bevel_minus NUMBER,holes_yn VARCHAR2(1),holes_v_yn VARCHAR2(1),
hole_x_dim NUMBER,hole_y_dim NUMBER,hole_dia NUMBER,no_of_holes NUMBER)
-- All the data which has to go under specific field for example **9005.nc1 will go into wo_no field, 1239401A will go under struct.
ST
** 9005.nc1 --WO_NO
1239401A - STRUCT
1 -REV_NO
9005 -MARK
9005 --POS
S275JR --GRADE
2 --QTY
[code]....
I need to upload data from XML file to oracle database table.For this I have referred some websites in which solutions given in a such a way that loading entire XML file into LOB column inside the table.But I want only data to be extracted from XML file.
Will SQL Loader be best option?
I am attempting to Insert an image "C:/hi.jpg" into oracle10g with BLOB using SQLPlus.
I have created a table IMAGES...
CREATE TABLE IMAGES (
ID NUMBER(4) PRIMARY KEY,
IMAGE BLOB
);
Is that a correct way to start? How would you upload the image onto the table?
I am new to the Upload data from excel to Table..... how to implement on this.....I need code for UpLoad CSV/XLS Files to the Table ....Table name T_UPLOAD have contains 40 columns....
View 3 Replies View RelatedI have to do upload into the table through a csv file . The table's primary key i have to load the rest through user's uploaded file. Is it possible to do the data loading to the table only to required columns and fill the other columns from backend. Or is there any other way to do this?
View 1 Replies View RelatedI needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.
Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):
CREATE TABLE "TABLE"."STG" (
"DUMMY01" NUMBER,
"DUMMY02" NUMBER,
"DUMMY03" NUMBER,
"DUMMY04" DATE,
"DUMMY05" CHAR(3 BYTE),
[code].........
And here's the insertion process:
DECLARE
v_blob_data BLOB;
v_blob_len NUMBER;
v_position NUMBER;
v_raw_chunk RAW(10000);
v_char CHAR(1);
[code]..........
If I run a process to produce the output of the data array onto the screen, the values displayed are in the pattern desired.
Inserting Dummy values instead of values from the Array (v_data_array) to test
EXECUTE IMMEDIATE 'insert into TABLE.STG (DUMMY01, DUMMY02 ..... DUMMY65)
VALUES (
60040,
5,
TO_DATE("14-Dec-12","DD-MON-RRRR HH:MI:SS"),
"ABC",
"ABC",
60,
"11DEC1201",
"331",
"SCOTT TIGER",
"MARKETING",
[code].......
Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.
How to delete SID name (oracle) from my computer ?
View 7 Replies View Relatedhow to Completely remove Oracle 11g from my computer ?
View 2 Replies View RelatedI have Oracle 11g downloaded on my laptop for personal use. Here are my specs-
Gateway T-6815
Processor: Intel® Core™2 Duo CPU T5250 @1.5GHz 1.50 GHz
RAM: 1.00 G
32-bit Operating System
Windows Vista -Home Premium
Disk Space Available : 16.8 GB free of 138 GB
Every time I start DBConsole it takes almost 30 minutes to start, slows down the computer to the point where its not usable and/or crashes it.
i am working on oracle 10g windows & all my disks are full and i want to add a datafile on other computer . how can i do it ?
View 11 Replies View RelatedIm doing a project for my college and i need to transfer database. The thing is that i have created tables with databases and linked it to VB using ADODC.
I have done all this in the Computer at my home. So i have done all the project in my computer. I want to show the same project in my college, but i cant do it as the database is stored in my personal computer at home. Is there any ways i could transfer the database from my house to college like storing it in a pendrive. I used sqplus
oracle 9i to create the tables.
I followed the "Loading data into your database cloud service from SQLDeveloper" tutorial, and I cannot upload a table that contains a column of type SDO_GEOMETRY. I get an error message that reads: "Unsupported Cart Object: Unable to deploy some objects to the cloud. These objects have been deleted from inclusion. Review Cart contents before redeploying. The following have an unsupported data type: SPATIAL.FLIGHT_TRACK." I can load any table that does not contain a n SDO_GEOMETRY column.
View 1 Replies View RelatedHow I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?
View 1 Replies View RelatedI need steps to install Oracle R12 on my Windows computer.
View 1 Replies View RelatedI am on H1 visa and working as chemical engineer...but I am bored of this job... I wanted to switch to IT and particularly oracle dba..
How much is the risk for me as I am coming from non computer science background..there are various IT consulting companies who can provide training and do h1 transfer......currently (year 2010) the market for oracle is booming a lot...so I was thinking what can go wrong if I do this switch.
I am trying to connect to a database located at my work from at home. I am running into the following issue (see command and error below):
ansichart@ansivm:~/src/perl$ sqlplus aspxdba/********@aspxp2 SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 18 21:15:09 2013 Copyright (c) 1982, 2011, Oracle.
All rights reserved. ERROR:ORA-12545: Connect failed because target host or object does not exist-- Here is my tnsnames.ora file (I have the service_name censored out for privacy reasons):-
ansichart@ansivm:~/src/perl$ cat $ORACLE_HOME/network/admin/tnsnames.oraaspxp2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orarac9-scan)(PORT = 1521)) ) (CONNECT_DATA =(SERVICE_NAME = *****************)(UR=A) ) )-
I have verified that I can establish a TCP connection to this DB server on the port specified, using the same info from the TNSnames.ora file (see below):-
---ansichart@ansivm:~/src/perl$ nmap -sT -p 1521 orarac9-scan Starting Nmap 5.21 (URL.... ) at 2013-07-18 20:53 CDTNmap scan report for orarac9-scan (10.1.13.115)Host is up (0.0088s latency).PORT STATE SERVICE1521/tcp open oracle Nmap done: 1 IP address (1 host up) scanned in 0.09 secondsansichart@ansivm:~/src/perl$--
I have another terminal opened up to a server at work and I can connect to the DB with sqlplus just fine. I verified that the record for this database on the tnsnames.ora file is the same as it is at work. In conclusion, I can connect to the Database at work, but I cannot at home, even though I am using the same connection information and verified that port 1521 is accessible on this Database server from at home. So why can't I establish a DB connection?
i m facing an issue about TNS connectivity after some time i start my notebook and then sql butt it can not be login from any side like sql,pl/sql,forms or reports it shows same error ora-12203 tns unable to connect to the destination also my service of oracleserviceORCL can not start it shows an error like 'windows could not start the service on local computer '
View 4 Replies View Relatedi've 0racle 9i database, i wanted to know the easiest way how to copy that database on another computer throw local network,
View 15 Replies View RelatedI am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found if i use select * from table name all the data will show
if a column name select * from table name where duty_date = '05-JAN-11'no data found
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.
how can i dump and transfer it to another year with the same table
View 6 Replies View RelatedI 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.
I was trying to load data from XML files to an Oracle database table.I followed these below steps to load that file data into a table. Created XML_DIR1 as oracle directory where i have kept all XML files.
Create table import_rpt_xml of xmltypexmltype store as binary xml; insert into import_rpt_xmlvalues (xmltype (bfilename('XML_DIR1','I-Yamanouchi-20040525-501.xml'),nls_charset_id('AL32UTF8')));
This insert shows below error: Error starting at line 80 in command:insert into import_rpt_xmlvalues(xmltype(bfilename('XML_DIR1', 'I-Yamanouchi-20040525-501.SGM'), nls_charset_id('AL32UTF8')))
Error report:SQL Error: ORA-31061: XDB error: XML event errorORA-19202: Error occurred in XML processingIn line 69 of orastream:LPX-00217: invalid character 142 (U+008E) I tried to look into my XML and got that it has some Japanese characters in it.
this to deal with japanese characters in XML. I don't want to miss those characters. My databse NLS_CHARACTERSET is 'AL32UTF8'.
My sample XML file looks like this.
<ichicsr lang="ja">
<ichicsrmessageheader>
<messagetype>ichicsr</messagetype>
<messageformatversion>2.1</messageformatversion>
<messageformatrelease>2.0</messageformatrelease>
<messagenumb>US-Yamanouchi-W2004050033-4</messagenumb>
<messagesenderidentifier>Yamanouchi</messagesenderidentifier>
<messagereceiveridentifier>PMDA</messagereceiveridentifier>
[Code]...
and so on.
I am having many different files and i want to use pure plsql to get these files stored as blob from a table then compress them into 1 files and store that into another table. I did some search and its like possible but didnt get conclusive solution
View 4 Replies View Relatedexporting a big table (many rows = 3.000.000). Using the command exp the error message returned is "expdat.dmp > EXP-00028: failed to open expdat.dmp for write". Is there a possibility to export this table in multiple files (as a splitter)?
View 10 Replies View RelatedHow can I know if database files are on file system or raw files?
View 4 Replies View Related