Exforsys

Online Training

Oracle data pump

This is a discussion on Oracle data pump within the Oracle Database forums, part of the Database category; I would like to know if there is a possibility of exporting only one column from a table with the ...


Go Back   Exforsys > Database > Oracle Database

Oracle data pump Oracle data pump

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 07-30-2007, 08:52 AM
Junior Member
  
Join Date: Jul 2007
Posts: 1
RachellT is on a distinguished road
Exclamation Oracle data pump
I would like to know if there is a possibility of exporting only one column from a table with the data pump?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 10-24-2007, 08:46 AM
Junior Member
  
Join Date: Oct 2006
Posts: 2
Uldis is on a distinguished road
No, the smallest unit, AFAIK, is still a table. You, however, can use "CREATE ... AS SELECT ..." or "INSERT ... SELECT ..." to make an additional table with column you need.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-18-2008, 06:35 AM
Junior Member
  
Join Date: Jul 2007
Location: Birmingham-UK
Posts: 12
Larry Cumber is on a distinguished road
Does this mean you cannot export an empty table with data pump?
Because you could export the metadata and exclude data.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« instalation of oracle9i | how do I get rid of the spaces at the »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Data Modeling Tutorials lokeshm Data Warehousing 0 04-24-2007 02:18 PM
difference between Data Warehouse and Online Analytical Processing techguru Data Warehousing 1 04-10-2006 11:25 AM
hierarchail & network kisshug Oracle Tutorials 2 05-01-2005 04:17 PM
Comp.software-eng FAQ (Part 0): periodic postings and archives David Alex Lamb Tech FAQ 3 04-18-2004 05:15 AM
Apple II Csa2 FAQs: Telecom Hardware & Transfers, Part 20/25 rubywand@swbell.net Tech FAQ 0 04-04-2004 07:29 AM


All times are GMT -4. The time now is 03:01 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.