Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export user definitions

Re: export user definitions

From: Joe Testa <teci_at_the-testas.net>
Date: Thu, 13 Sep 2001 15:45:51 -0700
Message-ID: <F001.0038DF1D.20010913154521@fatcity.com>

!! Please do not post Off Topic to this List !!

Here is what it does so far:

first off you HAVE TO GET a versio of strings that is NOT brain dead, meaning it has to be able to handle extremely long lines, no 1024/2048 max line length, you can get free source code for a better strings command from gnu look for binutils package.

ok that is covered:

it handles:

  1. sequences
  2. analyze
  3. comment on
  4. grant
  5. create table(yes normal, hash and range partitioned, no composite yet)
  6. regular, bitmap and unique indexes
  7. alter table
  8. create synonym.

Its far from done but it works pretty much for what i needed.

Its alpha software at best and for a small database, its almost easier to use OEM and reverse the few tables needed.

If there is interest, i'll upload what I have done to my website(its not the oracle-dba.com one, its the "the-testas.net" one.

drop me a private email(not to the list).

joe  

--

Joe Testa
Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :)
IM: n8xcthome or joen8xct
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 13 2001 - 17:45:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US