on 11-24-2015 11:31 AM
Hi Team,
We have requirement where we want to Export the system schema full data (including indexes , Table , Function etc) and import the same to another schema say system1 .so that if we are going to change any table inside system1 schema ,should not effect the system schema,,,
What will the shortest and simplest method for doing this.
Your suggestion will be really appreciable .
Regards
Rableen
Hi Rableen,
Below is one way of having same schema objects in another schema in same system and it worked.
Export:
Export the schema to Server/Client location using Export selection as Column table format = CSV
Import using SQL:
IMPORT "system"."*" AS CSV FROM '/usr/sap/HDB/HDB00/work' WITH
RENAME schema "system" to "system1"
You no need to change anything for catalog objects such as tables, views, procedures, indexes.
All these objects will refer to the new schema and are independent which points to its respective schema. This way you can have two schemas - 'system' and 'system1' in same system.
Hope it helps.
-- KRPK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I belive Import/Export method will be good.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan,
Once we will export the schema with SYSTEM1,while import we have to change the schema name from SYSTEM1 to SYSTEM2 , How many place we have to change as i wanted to export whole schema , so is there any other way available or while import mass change from SYSTEM1 to SYSTEM2.
Regards
Rableen
Hi Rableen,
The import statement has a rename schema option as per the syntax in the below page. Did you try that out?
Regards,
Sathish
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.