This page (revision-14) was last changed on 26-Nov-2021 10:22 by JAiken

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
14 26-Nov-2021 10:22 5 KB JAiken to previous
13 26-Nov-2021 10:22 5 KB JEscott to previous | to last
12 26-Nov-2021 10:22 5 KB JEscott to previous | to last
11 26-Nov-2021 10:22 5 KB JEscott to previous | to last
10 26-Nov-2021 10:22 5 KB JEscott to previous | to last
9 26-Nov-2021 10:22 5 KB JEscott to previous | to last
8 26-Nov-2021 10:22 5 KB JEscott to previous | to last
7 26-Nov-2021 10:22 5 KB JEscott to previous | to last
6 26-Nov-2021 10:22 5 KB JEscott to previous | to last
5 26-Nov-2021 10:22 5 KB JEscott to previous | to last
4 26-Nov-2021 10:22 5 KB JEscott to previous | to last
3 26-Nov-2021 10:22 5 KB JEscott to previous | to last
2 26-Nov-2021 10:22 5 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
COPY PILOT DATA TO PROD DB
COPY PILOT DATA TO PROD DB

Version management

Difference between version and

At line 14 changed one line
This will create two files in the current working directory of the system the command is run from. The first file, PILOT.DMP, will be used to load the data into the production database [PROD]. The second file, PILOT.LOG is only used as a reference, if something should go wrong during the export process.
This will create two files in the current working directory of the system the command is run from. The first file, PILOT.DMP, will be used to load the data into the production database (PROD). The second file, PILOT.LOG is only used as a reference, if something should go wrong during the export process.
At line 18 changed 2 lines
!Step 2: Drop P2K
Drop the contents of the PROD database. The database must be empty before new information can be loaded into it with Oracle import utility, IMP. High Line has provided an SQL script for removing all the objects from the Oracle database owned by the P2K user. To run this script, you must run SQL Plus, log on as P2k and issue the @DB_DROP command. This script can take some time to run, but should finish in about 20 to 30 minutes.
!Step 2: Drop [{$applicationname}]
Drop the contents of the PROD database. The database must be empty before new information can be loaded into it with Oracle import utility, IMP. High Line has provided an SQL script for removing all the objects from the Oracle database owned by the P2K user. To run this script, you must run SQL Plus, log on as P2K and issue the @DB_DROP command. This script can take some time to run, but should finish in about 20 to 30 minutes.
At line 21 changed one line
You may want to back up the database, prior to running this script. This SQL script will destroy all the P2K data in the database you are logged into. Make sure you have logged onto the correct database before running this script.
You may want to back up the database, prior to running this script. This SQL script will destroy all the [{$applicationname}] data in the database you are logged into. Make sure you have logged onto the correct database before running this script.
At line 38 changed one line
This SQL script makes no changes to the data in the database. It has only three functions, rebuild the public synonyms, re-issue grants to the P2K_USER role and to compile and invalid Oracle objects. At the end of the script you should see a line the states “NO ROWS SELECTED”. This indicated that there are no invalid objects remaining in the database.
This SQL script makes no changes to the data in the database. It has only three functions, rebuild the public synonyms, re-issue grants to the [P2K_USER] role and to compile and invalid Oracle objects. At the end of the script you should see a line the states “NO ROWS SELECTED”. This indicated that there are no invalid objects remaining in the database.
This page (revision-14) was last changed on 26-Nov-2021 10:22 by JAikenTop