kopiering af et SCHEMA
Kan man kopiere et helt schema med tabeller, konstraints, indices og brugere på en enkelt måde ?f.eks.
CREATE USER NEWSCHEMA as select * from OLDSCHEMA;
eller skal jeg igang med
CREATE USER NEWSCHEMA
IDENTIFIED BY VALUES '7FC886885CBBD457'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMPSMALL
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT DBA TO NEWSCHEMA;
GRANT CONNECT TO NEWSCHEMA;
GRANT AQ_USER_ROLE TO NEWSCHEMA;
GRANT AQ_ADMINISTRATOR_ROLE TO NEWSCHEMA;
ALTER USER NEWSCHEMADEFAULT ROLE ALL;
GRANT CREATE TRIGGER TO NEWSCHEMA;
GRANT CREATE ANY TYPE TO NEWSCHEMA;
GRANT CREATE PROCEDURE TO NEWSCHEMA;
GRANT UNLIMITED TABLESPACE TO NEWSCHEMA;
ALTER USER NEWSCHEMA QUOTA UNLIMITED ON USERS;
ALTER USER NEWSCHEMA QUOTA UNLIMITED ON TEMPSMALL;
ALTER USER NEWSCHEMA QUOTA UNLIMITED ON EPJIDX;
ALTER USER NEWSCHEMA QUOTA UNLIMITED ON EPJIDTA;
stor løkke med alle tabeller
create table NEWSCHEMA.TABLE1 as select * from OLDSCHEMA.TABLE1
stor løkke slut
