To restore the P6 Analytics sample database:
Note:
create tablespace STAR_DAT1
datafile 'path/STAR_DAT1.dbf'
Size 32m
Autoextend on
Extent management local;
where STAR_DAT1 is the name of the star tablespace, and path is the path to the folder where the database resides
create tablespace STAR_HST1
datafile 'path/STAR_HST1.dbf'
Size 32m
Autoextend on
Extent management local;
where STAR_HST1 is the name of the star history tablespace, and path is the path to the folder where the data files reside.
prompt Creating users username
--METADATA TYPE:USER CHANGE:CREATE NAME:username
create user username
identified by password
temporary tablespace temp_table
default tablespace STAR_DAT1
;
--METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:DBA GRANTEE:username
grant dba to username;
--METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:JOB GRANTEE:username
grant create any job to username;
where username is the name of the user for the Star database, password is that user's password, temp_table is the name of the tablespace for temporary data, and STAR_DAT1 is the name of the Star tablespace
create directory dmpdir as 'path_to_file';
where path_to_file is the location of the data extracted from the sample_expdp.zip file.
alter system set sec_case_sensitive_logon=false;
impdp system/password@SAMPLE directory=dmpdir dumpfile=star32.expdp schemas=username logfile=sample.log
where dmpdir is the directory that you created and username is the name of the user you created
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014