Re: wildcard in imp73.exe

sharon Viente wrote:
>
> Hello,
>
> 1. Could somone tell me how to export and then import from two Oracle7
> servers (Unix to NT) more than one table at a time . I am using
> exp73.exe?.
> My tabless have the same preffix so i need wildcard expression (something
> like exp73 myfile_*).
> 2. Is there another way of copying files from one server to the other if
> they are on the same network.
>
> Sharon.

Sharon,

there are several ways to copy a table from one instance to another on the same network:

	SQL*Plus COPY command - very versatile and the most unused
	Insert into select - not very versatile because commits are ot 		
	 controlled and rollbacks can get big - but it's easy
	Export/Import - wildcards are not supported but you can export
	 by owner if this helps. If this is not an option then you can
	 do this in sqlplus to generate a dynamic list of tables and
	 then use the export with parfile=my_parfile.lst

	  set pagesize 0 termout off verify off feedback off
	  column max_table new_value max_table_name

	  select max(table_name) max_table
	  from all_tables
	  where table_name like 'MYFILE_%';

	  spool my_parfile.lst
	  select 'tables=(' from dual;
	  select table_name||decode(table_name,'&max_table_name,')',',')
	  from all_tables where table_name like 'MYFILE_%';
	  spool off

Hope this helps,
Marc

Check out our utilities at http://dbghome.computek.net

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->