This content has been marked as final. Show 12 replies
As far as I know (please correct me if I'm wrong) you cannot specify an alternate path where to store the application when copying the cube.
But what you could do is specify another location for the data files. For that you could use the alter tablespace statement of MaxL.
For details (11.1.1.x) see:
I have tried the table space option too. But, I after restarting the application it is just creating a folder with application name in the alternate path with inside empty folder default. I didn't under stand clearly how could it work. Can i push the database inside to this newly created folder?
I have tried the option alter system set eas_loc 'alternatepath'; also. this statement is executing successfully but after that also copy application is creating in regular folder only. I think some needs to change the application storage settings.
The folder structure and certain files will always exist on the drive where Essbase was installed for both ASO and BSO. For example, the database directory that contains the outline and load rules. If you change the tablespaces for the data and the temp space, it means the new location will be used for those. If you do an application copy from EAS, there is no way to specify the new location for those files during the copy. IT would copy them to the Essbase path, you would then need to change them and reload the data
Thanks for your reply.
Could you please tell me wether the below plan will work or not.
1. Will create a copy application in current drive
Create application TEST1 as REAL1;
2. alter the table space
alter tablespaceTEST1.'default' alter file_location 'targetpath' set max_filesize or max_disksize;
3. Reload the databse
alter application TEST1 unload database test1;
alter application TEST1 load database test1;
I think this will not work.
Changing the tablespace would mean that you would have to add new one and remove current one. Than as stated by Glenn already you have to completely reload the data.
However what you could try is a filesystem copy of the old tablespace files on the drive to the new one - may be this will work as well so you wouldn't have to completely reload all data.
So I would try:
- Copy application using MaxL
- Add tablespace for new drive
- copy files of old tablespace to new one
- delete old tablespace
- reload app and test if data is still there
As I don't know if it will work, please don't test this on a productive system.
I hope copy table space files will not work. Since, I need the entire process to be automated. We can't copy files trough Maxl. I have tried changing the table space and loading the data in copy application. It is storying dat files in copy application.
I think there is no option to copy entire database to newlocation with all the scripts and databse folder. any way I am proceed with changing table space. Hope so client will accept this.
Is it possible to you copy an application without the data then make an export/import from one application to another?
Once i have done that in an BSO cube. Even though i made it manually. I don't know if its possible to automate the process.
1 - Copy Sample.Basic to TEST.Basic (without data).
2 - Alter tablespace of TEST.Basic
3 - Export data Sample.Basic (define some directory)
4 - Import data into TEST.Basic.