Server Utilities :: How To Upload Photos In Oracle Database

Jun 25, 2012

i have 1500 images in jpeg format i want to upload this immages into my oracle database

i did this steps using google serach

1) Create the table as follows

Quote:SQL> CREATE TABLE image_table (file_id NUMBER(5),
2 file_name VARCHAR2(30),file_data BLOB);

Table created.

2)

Create the control file as follows in notepad and just give a name control.ctl ....ctl extension is needed

Quote:LOAD DATA
INFILE *
INTO TABLE ron.image_table
REPLACE
FIELDS TERMINATED BY ','
(
file_id INTEGER EXTERNAL(5),
file_name CHAR(30),
file_data LOBFILE (file_name)
TERMINATED BY EOF
)
BEGINDATA
1,F:Koala.jpg

3)

Run this command on command prompt

F:oracleproduct10.2.0db_1in>SQLLDR control=E:control.ctl
Username:system
Password:

SQL*Loader: Release 10.2.0.5.0 - Production on Thu Jun 9 16:20:17 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Commit point reached - logical record count 1

4)
Now check this image file load in oracle by using this

SQL>
SQL> Select file_id,file_name,DBMS_LOB.GETLENGTH(file_data ) Length from Image_table;

FILE_ID FILE_NAME LENGTH
---------- ------------------------------ ----------
1 F:Koala.jpg 780831

SQL>

but actuly i want to file_name is my actul employee name like Ramesh Patel so what are the changes i can do into my this control file so i can get this file name as my employee name and using this tool i can upload 1500 images into database easily

View 14 Replies


ADVERTISEMENT

Server Utilities :: Geometric Data From Text To Table And Wrong CTL Upload Into Table

Jul 11, 2013

I 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]....

View 24 Replies View Related

Forms :: FRM-40735 Upload And Download On Database Server Give Error?

Mar 12, 2013

i have succusffly install webutil and also i did configuration also using this url

[URL]...

and i succussfuly upload and download .pdf using my form on my test database server my test database its a single database its version also 10.2.0.4.0 .but when i upload and download my .pdf file on my live database server using this same form its give me error while upload

Quote:FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509

my live database server its a RAC Database server its version 10.2.0.4.0 . i serach on google on this ora-06509 they told me

Cause: This indicates a version clash between some package distributed with an Oracle product and the product executable.
Action: Contact Oracle Support Services.

but my question its my test database server and live database both server version are same its 10.2.0.4.0 just only its differece its test database its a single database server and live its a rac database server.

View 14 Replies View Related

Server Utilities :: Load JPG Picture Into Oracle Database?

Jun 8, 2011

i want to load jpg into my oracle database 10g throw sqlloader

i did folloing steps

step 1)

Create the table as follows

CREATE TABLE image_table (file_id NUMBER(5),
file_name VARCHAR2(30),file_data BLOB);

step 2 )

Create control file as follows

LOAD DATA
INFILE *
INTO TABLE image_table
REPLACE
FIELDS TERMINATED BY ','
(

[code].....

step 3)

Then i have run this command

F:oracleproduct10.2.0db_1in>sqlldr control=F:practicecontrol.ctl
Username:system
Password
so i got this error
SQL*Loader: Release 10.2.0.5.0 - Production on Wed Jun 8 13:47:27 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-404: Column FILE_ID present more than once in IMAGE_TABLE's INTO TABL
E block.

View 4 Replies View Related

Server Utilities :: Import Oracle 10g Dump Into 9i Database

Mar 31, 2010

If I want to import 10g export dump file in to the 9i database, I am connecting to 10g database from 9i database using
exp user/password@10gdb ....

However is there any option like executing 9i catexp.dat on 10g database and do the export from 10g database itself to be imported into 9i?

View 6 Replies View Related

Server Utilities :: Import 1 DMP File Into Oracle Database?

Sep 16, 2008

I want to import 1 .dmp file into oracle database. I dont know what exactly what that .dmp file contains e.g i dont know the Users inside the dump.While importing it gives me the error.

1. Do i need to create those users first and then import if yes then how would i know how many users are inside that dump.

2. Currently the objects are created in SYSTEM user by default. I want to import those objects in the MACL user which i created. How can i do it?

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:

[Code]....

View 2 Replies View Related

Server Utilities :: Import And Export Database In Oracle?

Oct 11, 2011

import and export database in oracle with proper example and procedure?

View 3 Replies View Related

Server Utilities :: Import Dump Into Oracle 10.2.0.3.0 Database On Win 7 Professional Laptop

Nov 12, 2010

I am trying to import a dump into my oracle 10.2.0.3.0 database on my win 7 professional laptop. The dump is exported from my win xp desktop pc running Oracle 10.2.0.1.0

Below is the error i get:

Import: Release 10.2.0.3.0 - Production on Fri Nov 12 15:57:52 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: system/password@orcl

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: EXPDAT.DMP > F:PersonalDPISIMBA.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no >
Username:paymaster

Enter table<T> or partition<T:P> names. NULL list means all tables for user
Enter table<T> or partition<T:P> name or . if done:

when I press enter key, the console hangs and a window appears with "Console Window Host has stopped working" then the console closes prematurely.

View 1 Replies View Related

Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File

Aug 24, 2012

I 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 Related

Server Utilities :: Finding Versions Of Exp And Imp Utilities Of Database Server?

Feb 23, 2012

how to find the versions of exp and imp utilities of database server from windows command prompt?

Note: Currently i have 10.2.0.10 oracle software installed on my local machine.

View 4 Replies View Related

Server Utilities :: Import Table From Another Database By Using Database Link?

Mar 17, 2010

i would like to import a table from another database by using database link.

impdp muba/muba tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1

i created the public database link as system user

it gave error like

Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:07:02
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "MUBA"."SYS_IMPORT_TABLE_01": muba/******** tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

[code]....

after that i try to import as system user like

impdp system/passwd tables=FUNCTION_NO schemas=muba directory=testdump NETWORK_LINK=DBLINK1

but error like

Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:27:43
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
UDI-00010: multiple job modes requested, schema and tables.

when i use IMP utility

imp system/passwd file=dump.dmp fromuser=userA touser=userB log=dmplog.log but when i use IMPDP what is the parameter equal to fromuser & touser

View 3 Replies View Related

Server Utilities :: Import Whole Database To Another Database

Dec 7, 2011

Is it possible to import one whole database in to another whole database?

View 4 Replies View Related

Forms :: Upload PDF File To Server

Jan 23, 2013

I'm using oracle 10g and Forms 9i . I need to upload a PDF file from client to server no to database, just like File, is there any way to get it, no webutil using.

View 1 Replies View Related

Server Utilities :: Moving Database Using Exp / Imp?

Sep 23, 2010

I need to move database ORCL into our existing central database CNTR (both are on same OS and oracle version) I started exp each schema from ORCL and imp in CNTR.

But there is one schema EXMP in database ORCL which also exists in CNTR database with same tables, indexes . The data under schema EXMP in ORCL should be added to schema EXMP in CNTR.

View 9 Replies View Related

Server Utilities :: How To Import A Database

May 22, 2011

I do not import a full database.

View 3 Replies View Related

Server Utilities :: Exporting Database?

May 31, 2010

I am Trying to Export my database and whenever I try to login it is giving Ora-Error 1017 Invalid Username/Password.

If I Login as System and Manager it is accepting but I am not able to Export all my Database.

View 9 Replies View Related

Server Utilities :: Reg Database Directory

Feb 12, 2013

On last week we have migrated our oracle database from 9i to 10g through imp utility ,but now i have facing one small issue where as new have our old live database with us and suppose we have fired

"SELECT* FROM V$PARAMETER WHERE NAME LIKE 'utl%'"

to check directory name and valus then in output its shown name:-utl_file_dir and valus:-E:RAB but in our new database its does not shown any value like E:RAB in migrated database as i have recreated that directory in new database but still that issue persist .

View 3 Replies View Related

Server Utilities :: Move Objects From One Database To Another?

Jun 2, 2011

I want to move 350 database objects from one database to another database schema.

View 16 Replies View Related

Server Utilities :: Importing Full Database With Different Name And Sid

Oct 20, 2011

Source:Oracle 11g 11.1.0.2 32 bit on Windows 2003,Destination: Oracle 11g 11.1.0.2 64 bit on Windows 2008

In our Source Database, we are using following to create full export

Source database_name=dbfour,sid=dbfour1

I am creating full export by using following

expdp system/psswd full=y dumpfile=expdp_%date:~0,2%-%date:~3,2%-%date:~6,4%.dmp logfile=explog_%date:~0,2%-%date:~3,2%-%date:~6,4%.log FLASHBACK_TIME="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')"

In my destination DB with database_name=dbfive and sid=dbfive1, i am trying to import whole database by using the file created above and use following

impdp system/pwd@dbfive DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXPDP_20-10-2011.DMP

Process started but after sometime it gave 1200 errors. Is it due to the Different Database name or Is it because i did not create table space in destination database.

View 3 Replies View Related

Server Utilities :: How To Import DMP File To Database

Apr 30, 2012

I am trying to import .dmp file to my database

I am trying to run the imp command from dos prompt.

Here is the error I got .

C:Documents and SettingssairammMy Documentsartmsexp_AUDT2_04292012>imp
sairamm/mypassword@aws fromuser=AUDT2 toUSER=SAIRAMM file=exp_AUDT2_04292012.dmp
log=imp_AUDT2_04292012.log BUFFE
R=10000000 GRANTS=y
Import: Release 9.2.0.1.0 - Production on Mon Apr 30 14:23:29 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing option

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

View 2 Replies View Related

Server Utilities :: Moving Database 9i To 10g New Hardware?

Jun 18, 2010

I want to move oracle database 9i on win server 2003 32-bit to be oracle database 10g R2 on win server 2003 64-bit on a new hardware.

View 2 Replies View Related

Server Utilities :: Database Installation Using ASM In DBCA

Mar 6, 2010

I have installed asm lib and asm instance has started successfully and is working if i am using

EXPORT ORACLE_SID=+ASM

but if I am using DBCA after that to create database on ASM activated disk group I am having problem in creation of spfile. How to follow steps to create database using already installed /mounted disk group with DBCA.

View 1 Replies View Related

Server Utilities :: Clone Database User

Aug 1, 2011

I want to create such a script to clone the Database user with the new name. Just like we do normal import and export I want that i should enter just the username of the existing user and username of the new user I want to get created, the password for the same.

It should create the new user with all roles and the default roles and privileges of old user.

View 39 Replies View Related

Server Utilities :: Unable To Import 3 Different Database

Jan 22, 2013

I need to import one schema into 3 different DBS. out of 3, have imported into 2 databases without any error. during 3rd import iam getting below error:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP and Data Mining options.
ORA-31626: job does not exist
[code]....

I am using same parfile. no changes on the syntax. this is a schema export.

---partfile content
> more QSHOUT_ALARMPOINT4_import.par
directory=APP_EXPORT
dumpfile=exp_PSHOUT_01182013_ALARMPOINT4_SCHEMA.dmp
logfile=exp_PSHOUT_01182013_ALARMPOINT4_SCHEMA_impQSHOUT.log
TABLE_EXISTS_ACTION=truncate
parallel=2
cluster=n
full=y

View 6 Replies View Related

Server Utilities :: Imp / Exp Using RMAN Duplicate Database

Apr 23, 2010

I try to use rman duplicate database to bring entire databse form Windows XP system to another Windows XP. I have been trying to use rmain duplicate database without success.

I failed on "startup force nomount......". The system always prompt me an error as "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" and following by TNSLSNR.exe has encountered a problem and need to be close......"

I have tried to re-install the oracle multiple times and failed at the same problem as above. So, I am thinking of using imp and exp to do the work. Is it possible? If yes, how to do it.

View 5 Replies View Related

Server Utilities :: Import 9i Dumpfile Into 10g Database?

Aug 6, 2011

Is it possible to import a 9i dumpfile (taken by tradition export method) into 10g database using datapump import?

9i and 10g are database version

View 7 Replies View Related

Forms :: Upload A File From The Client To App Server In Runtime?

Jul 16, 2013

I need to upload a file from the client to app server in runtime.

Opening some kind of explorer to choose the file then upload the file and safe the path in a database column.

View 3 Replies View Related

Forms :: Upload Files From Client To Application Server Using 10g

Oct 3, 2010

I 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 Related

Forms :: Upload File Using Oracle 11g

Nov 6, 2013

Do you have sample codes to upload file from client to server using 11g forms?

View 2 Replies View Related

Server Utilities :: Importing Data From SQL Server To Oracle?

Mar 7, 2011

I'm importing data from SQL Server to Oracle. I used BCP to export the data from SQL Server. Below is the 1st record of table trlc from the csv file.

trlc.CSV

11032|100|Wman| | |2008-02-08| |

Using SQL Loader to import into Oracle:

TRLC table in Oracle database:

est_no varchar2(10) default ' '
right_no number(4) default 0
maj_auth varchar2(15) default ' '
weight varchar2(10) default ' '
idm_ht varchar2(8) default ' '
c_date date
P_tkt varchar2(5) default ' '

sqlldr user/pwd@db02 control=trlc.ctl log=trlc.log

trlc.ctL:

load data
infile 'trlc.csv'
replace
into table trlc
fields TERMINATED BY '|'
TRAILING NULLCOLS
(est_no,right_no,maj_auth,weight,idm_ht,c_date,P_tkt)

The rows get inserted successfully. But the result sets are different, for example: When I do a select in SQL Server,'select len(weight) from trlc;' , I get the length as 0. But when I do a select in oracle database, I get the length as 1. Also, the result set varies for the query below:

select * from trlc where weight=' ';

(SQL Server returns 1 row but Oracle returns no rows)

Do I need to mention any conversion code for the weight field to accept ' ' value?

View 12 Replies View Related







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