Current Position:Home > Export a long list of tables

Export a long list of tables

Update:11-30Source: network consolidation
Advertisement
Hi Guys,
I want to export a long list of selected tables, i can retrive table names from database dictionary, how can i copy my script in sqlldr instead of typing each table name, there might be any easy option, i might not know, any help would be greatly appretiated?
exp scott/[email protected] file=d:\ar_18_7.dmp tables= (a,b,c,d,e,f,g, .......................................)
log=d:\poi_release_impexp\ar_poi_18_7.logi just do not want to type 100 table names, any alternate where i could paste table names retrieved from tabs.
Thanks in advance,

The Best Answer

Advertisement
Hi,
There are loads of tools to choose from. Personally I always use datapump. As an example of how you can generate a table list dynamically for an export here's an example.
include=TABLE:"IN (SELECT table_name from dba_tables where owner='ENDURF_ENV01' and temporary='Y')"
This includes all tables that match the criteria -the SQL can be pretty much anything you like.
Cheers,
Harry
  • PROBLEM IN EXPORTING DATA FROM A RELATIONAL TABLE TO ANOTHER RELATIONAL TAB Update:10-11

    Hi, While trying to export data from a source table to a target table, problem occurs with loading the data in the work table(SrcSet0)[As shown in the operator]. The Work Table has been dropped and created successfully, the problem is coming with loa

  • How to export data from a Oracle table to a delimited file? Update:10-11

    I know how to load delimited file into a table, but how to export data from a Oracle table to a delimited file? Thanks in advance.Try looking at this link, it's long but there's three different solutions discussed in it. If you look at Barbara Boehme

  • How to export data from a Dynpro table to Excel file? Update:10-11

    Hi Here I go again. I read the post <b>Looking for example to export data from a DynPro table to Excel file</b> and put the code lines into a Web Dynpro Project where we need to export a dynpro table to Excel file but exactly at line 23 it doe

  • How to export some data from the tables of an owner with integrity? Update:10-11

    Hi to all, How to export some data from the tables of an owner with integrity? I want to bring some data from all tables in a single owner of the production database for development environment. My initial requirements are: seeking information on com

  • EXPORT to MEMORY ID Vs. EXPORT to DATA BASE IDX table?? Update:10-11

    Hi, Some times we use EXPORT to MEMORY ID and some times we EXPORT to DATABASE IDX table, pls. let me know, 1) When we use EXPORT to MEMORY ID? 2) When we use EXPORT to DATA BASE IDX table? 3) I knew that in the (1) case, data wuld be stored in share

  • Exporting Data Of an RDBMS Table to another RDBMS Table using ODI Functions Update:11-30

    Hi, I'm facing a problem while Exporting Data Of an RDBMS Table to another RDBMS Table using ODI User Functions. Name:- User_Func Group:- Training Syntax:- User_Func($(SrcField)) Implementation Syntax:- (CASE WHEN $(SrcField) > 40000 THEN 'HIGH' WHEN

  • Export a subset of a table Update:11-30

    Hello, I am trying to export some columns from a table. For example, I want to export just a set of columns of a table. I tried with the exp command and the option query but it doesn't seem to be possible. Can someone help me ? Thanks ! DelphineWhy n

  • Goto: How to export some data from the tables of an owner with integrity? Update:11-30

    Hi to all, Help please: How to export some data from the tables of an owner with integrity? My thanks in advance, PhilipsThanks, Peter. Well, I am working with release 9.2.0.8.0. But the planning is migrate to 10g this year. So my questions are: With

  • Grant export  only on few selected tables? Update:11-30

    Hi, Please let me know. Is it possible to give "grant" to any user to take "export" on only 4 tables. Thanks SurajRegarding export and import there are 2 roles EXP_FULL_DATABASE IMP_FULL_DATABASE If you have these two priviledges, you

  • To export and import oracle 11g table data only Update:10-11

    Hi Gurus, Just not sure of the procedure to follow in the export just the table data and then truncate the table do some changes(not table structure changes ) and then import the same table data in to the relevent table . Could some please help me in