Workspace import [message #679320] |
Fri, 21 February 2020 03:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I am trying to create a workspace which is a copy of an existing workspace. If it were in a different database, it would be easy: export the workspace and import it, either through the APEX GUI or by running the .sql file. But I have to do it within the same APEX instance, and the GUI refuses to import it because it already exists.
Is there a standard method for doing this? Or would it be OK to edit the export .sql file and replace all occurrences of the workspace_id (11 of them) with some other number? What about the workspace name?
Thank you for any insight.
|
|
|
Re: Workspace import [message #679321 is a reply to message #679320] |
Fri, 21 February 2020 04:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I tried a test, in a 19.1 instance:
Created a workspace, exported it.
Edited all occurrences (just 4) of the workspace_id to a new number, edited all occurrences of the workspace name to a new name.
Ran the import in the GUI.
It went further than before, it did start to do it, but failed with "Workspace did not create because it already exists."
So there must be something else in the export file that identifies it.
|
|
|
|
Re: Workspace import [message #679432 is a reply to message #679406] |
Fri, 28 February 2020 05:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Thank you for replying, it gets further. But not all the way! I then get errors regarding users not being unique. Now, we all know that users are unique within a workspace but apparently there is something in there that makes them unique in the instance as well.
I've given up on this, we'll clone the whole PDB to a new database instead. Once I get it upgraded to 19c I can do that within the CDB, but for now it will have to be a totally separate instance and database.
I have heard that Joel Kallman (you know him? The APEX God, and very responsive to direct contacts) has said that soon there will be a new export/import facility that should clear up a lot of the hassles.
|
|
|
|