Hi, I am pretty sure that 11g is the version of Oracle we're running, but I have a note in to our DBAs to confirm that. I did a quick scan of the dspace_tech mail list archive, however, as your message sounded familiar, and I found this thread:
http://dspace.2283337.n4.nabble.com/Error-with-workflow-in-DSpace-1-8-2-td4 505171.html#a4529981 Is it possible you've enabled configurable reviewer workflow? Other things to check: there's a handy ant target in the DSpace. Build.xml file, called "test_database" and you can use it to sanity-check your credentials. I don't think ORA-00942 will be thrown due to incorrect credentials, but, it's worth checking. -- HARDY POTTINGER <[email protected]> University of Missouri Library Systems http://lso.umsystem.edu/~pottingerhj/ https://MOspace.umsystem.edu/ "Don't undertake a project unless it is manifestly important and nearly impossible." --Edwin Land On 7/9/12 1:23 PM, "Kelly Brown" <[email protected]> wrote: >I am attempting to setup DSpace 1.8.1 with Oracle 11g. During the ant >fresh_install it creates the tables but after that during the ant command >I get the ORA-00942 table or view does not exist. I am able to connect >to the database and > see that the tables were created and they do exist. I have run the >oracle command found in the DSpace docs, I have change to pom file to >reflect the oracle database and have installed the ojdbc6.dll to maven. I >am at a loss as to why it creates the tables > but then tells me they don¹t exist. If there is anyone who is using >oracle with DSpace could you please let me know what version you are >using. Any ideas or help regarding this would be wonderful. > >Thanks, > >Kelly Brown >Database Analyst > >Massey Library | >Bibliothèque Massey >College Information Services | Collège des services d'information >Royal Military College of Canada | Collège militaire royal du Canada >National Defence | Défence nationale >PO BOX 17000 Station Forces >Kingston, Ontario K7K 7B4 > >Telephone / Téléphone: (613) 541-6000 x 6979 >E-Mail / Couriel: >[email protected] > > > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
