FilesExpand file tree

 master

/

makeallimp.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

20 lines (15 loc) · 340 Bytes

 master

/

makeallimp.sql

Top

File metadata and controls

• Code
• Blame

20 lines (15 loc) · 340 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

-- create imp parfile for each owner in tablelist

-- takes oracle userid and password as parameters

set echo off

set termout off

set heading off

set feedback off

set newpage none

set linesize 1000

set trimspool on

set verify off

spool allimp.sql

select distinct '@makeoneimp &1 &2 '||table_owner from tablelist;

spool off

@allimp

exit