Re: Convert 7.3 users to 8.17 users

2001-08-29 Thread nlzanen1
Hi, I can't test on 7.3 anymore but try following kind of script (it seems to work between 8.0 & 8.1 databases ** ORACLE_SID=EWIP export ORACLE_SID sqlplus -s / <@fatcity.com on 28-08-2001 23:07:54 Please

Re: Convert 7.3 users to 8.17 users

2001-08-28 Thread Jared . Still
-- -- clears.sql set pause off set echo off set trimspool on set feed on term on echo off verify off set line 80 set pages 24 head on clear col clear break clear computes btitle '' ttitle '' btitle off ttitle off --- -- clear_for_spool.sql @@clears set pages 0 lines 200 term on feed off --

Convert 7.3 users to 8.17 users

2001-08-28 Thread Bartolo, David
Hi all Can I take all the users created in a 7.3 database and somehow import them into a 8.1.7 database with the original passwords and roles/access to tables? TIA David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat Cit