Thanks MF, Infact I was looking for restoring the "sample data" in oracle. I did find in KB but it was for MS Sql server. If you know please help me out
The command is to be pasted in a dosbox on the oracle server (asuming windows here) or on the C8 server which has all the full oracle client installed.
Let's break the line down to pieces:
imp gosl/gosl@orcl = imp is the oracle import command and gosl/gosl@orcl means that you login into oracle instance "orcl" with the oracle username "gosl" and the password "gosl".
Of course the user gosl with the same password has to be created before running the command.
file=c:\temp\GOSL.DMP = The lcoation of your file to be imported. I hate long path names, so i always copy the oracle user dumps from the C8 sample directory to my c:\temp folder.
fromuser=GOSL = The cognos oracle export includes the user name it was exported under. In this case GOSL.
touser=gosl = This is the oracle schema user where the export needs to be written to. Like i said, the user allready has to be there, with the rights needed as mentioned in the installation guide.
For the other 2 oracle exports connected to the cognso_samples.zip deployment file, the lines would be:
Stefan, the OS is windowXP, the DB version is 10.2.0.1.0 and all this is loaded in my laptop. I tried the above command still getting the same error. is there any number I can reach you if you want you can reach me at 703-747-3899
Stefan, this is the command I have written imp cognos_cs/cognos_cs@bea0 file=C:\Program Files\cognos\c8\webcontent\samples\datasources\oracle\GOSL.DMP fromuser=GOSL touser=cognos_cs full=y log=gosl.log ignore =yes
and I'm getting error IMP-00002 fialed to open imp cognos_cs/cognos_cs@bea0 file=C:\Program Files\cognos\c8\webcontent\samples\datasources\oracle\GOSL.DMP fromuser=GOSL touser=cognos_cs full=y log=gosl.log ignore =yes for read
Stefan, The command was perfactly fine its running and I imported the GOSL. I was missing the quote '' which is
'C:\Program Files\cognos\c8\webcontent\samples\datasources\oracle\GOSL.DMP' thanks for all your help.
I tried to import GORT with the same command I'm getting error ORA-00001: Unique Constrained(cognos_cs.sys_c006061) Violated.
I have created a line chart on y axis I have numers and on Xaxis i have moths but when the chart run the line are not starting from the origin(0)if somebody knows please help me out. if you need further info please let me know
Ben,
You're not helping yourself here (or you're having a bad day).
You haven't replied to Stefan and you're asking a completely unrelated question instead.
Dear drlex, I got new and urgent assignment that's why I have to leave it in the midle once this report is finished I'm going to work on it. I'm the only person who is working on the cognos if its hurt you or Stefan in anyway I apolosize for that. Please help me out
Ben,
I'm not upset or offended by your post; the problem is that you're unlikely to get answers to a question about charting in a thread about restoring from backup.
I suggest you might post a new thread and put in a bit more detail (e.g. Cognos application and version). FWIW, if it's Series 8 or ReportNet, I'm afraid I can't help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.