| Exporting a row [message #72924] |
Mon, 15 December 2003 22:59  |
leena
Messages: 8
Registered: September 2000
|
Junior Member |
|
|
Hi Friends,
Iam facing a unique problem ..Please help me.
My Team leader wants me to export data from a Table which has one Long column in row wise. That means each row in the Long column should be exported in a separate file.
Export allows to export only users,tables and entire database.
What tool should I use or can I do it with PL/SQL or Pro*C.Please guide me.
Waiting 4 ur reply ....
|
|
|
|
| Re: Exporting a row [message #72925 is a reply to message #72924] |
Tue, 16 December 2003 03:02  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
[code]IF THE rows are less
and
if there is a primary key in the table , there is a easy way.
u can actaully select a part of table using queries in export.
mag@mutation_mutation > desc l1
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
DEPTNO NUMBER
DNAME LONG
mag@mutation_mutation > select * from l1;
DEPTNO DNAME
---------- --------------------------------------------------------------------------------
20 RESEARCH
30 SALES
40 OPERATIONS
mag@mutation_mutation > !
bash-2.03$ exp mag/mag tables=l1 query="where deptno=30"
Export: Release 9.2.0.1.0 - Production on Tue Dec 16 08:02:34 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table L1 1 rows exported
Export terminated successfully without warnings.
bash-2.03$ exp mag/mag tables=l1 query="where deptno=20"
Export: Release 9.2.0.1.0 - Production on Tue Dec 16 08:02:44 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table L1 1 rows exported
Export terminated successfully without warnings.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
