Scripts can be divided into two parts:
Synonym
1: synonym.cmd:
SQLPlus
Scott / Tiger @ SDF154 @ synonym.sql
2.Synym.sql:
Create Table Tmp_User_Synym As SELECT '|| Synonym_Name || CHR (13) ||' for '|| CHR (13) || Table_owner ||'. '|| Table_Name || CHR (13) ||' / 'Text from user_synynyms;
Set Heading Off Feedback Off Termout Off
SET PAGESIZE 0
Set linesize 100
Set long 100000
COL TT FORMAT A
Spool d: /bat/synonym.log;
Select text tt from tmp_user_synonym;
Spool OFF;
Drop table tmp_user_synonym;
EXIT;
Everyone can use an anti-three, the series of writing can refer to the following:
Drop table tmp_user_sequence;
CREATE TABLE TMP_USER_SEQUENCE (Text Varchar2 (4000));
Declare
Begin
For tt in (select * from user_sequences) loop
INSERT INTO TMP_USER_SEQUENCE VALUES ('Prompt');
INSERT INTO TMP_USER_SEQUENCE VALUES ('Prompt Create Sequence' || TT.SEQUENCE_NAME);
INSERT INTO TMP_USER_SEQUENCE VALUES ('Prompt');
INSERT INTO TMP_USER_SEQUENCE VALUES ('Create Sequence' || '|| TT.SEQUENCE_NAME);
INSERT INTO TMP_USER_SEQUENCE VALUES ('minvalue' || '' || tt.min_value);
INSERT INTO TMP_USER_SEQUENCE VALUES ('maxValue' || '|| tt.max_value);
INSERT INTO TMP_USER_SEQUENCE VALUES ('Start with' || '' || tt.last_number);
INSERT INTO TMP_USER_SEQUENCE VALUES ('increment by' || '' || tt.increment_by);
INSERT INTO TMP_USER_SEQUENCE VALUES ('cache' || '' || to_char (tt.cache_size);
IF tt.cycle_flag = 'y' Then
INSERT INTO TMP_USER_SEQUENCE VALUES ('Cycle');
END IF;
IF tt.order_flag = 'y' Then
INSERT INTO TMP_USER_SEQUENCE VALUES ('ORDER');
END IF;
INSERT INTO TMP_USER_SEQUENCE VALUES ('/');
INSERT INTO TMP_USER_SEQUENCE VALUES (''); End Loop;
COMMIT;
END;
/
Set Heading Off Feedback Off Termout OFF;
Column Text Format A100;
Spool d: /bat/user_sequences.log
Select text from tmp_user_sequence;
Spool OFF;
EXIT;
