Tagged Questions

0
votes
2answers
45 views

Oracle 10XE: Stop schemas seeing the all_users table?

I've got an Oracle 10g XE Database that I want clients to be able to view remotely via SQL*PLUS or SQL Developer. Each schema has a name which includes the name of the client, so anyone looking at the ...
1
vote
1answer
21 views

Oracle Express intermittently stops responding, requiring a OS reboot to fix

I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out. There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
1
vote
4answers
111 views

Copying my Oracle 10g Express database to another PC

I have Oracle 10g Express. How can I make a copy of my database and application? I don't want to make a back up, I want to move my DB and application to another PC.
0
votes
1answer
147 views

Set encoding from within SQL*Plus

I have a large set of files with SQL commands that I run with a SQL*Plus script that uses the @@ operator. I run the script on third-party computers (or even send it by e-mail) so I'd like to make it ...
0
votes
0answers
756 views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
1
vote
1answer
1k views

Difference between database dump (export) and database backup?

What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
2
votes
1answer
2k views

Installing Oracle 11g XE on Ubuntu 12.04

I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how ...
1
vote
2answers
273 views

Trigger to automatically add values to a table in Oracle

I am new to Oracle. I am looking for a trigger which helps to automatically insert values into a table when data is entered into another table in the same database. I have tried a lot and didn't ...
0
votes
1answer
919 views

How do I discover the Oracle Express workspace name?

Is there a way to discover the WORKSPACE name if I've forgotten it? I cannot login to the APEX admin console since I've forgotten what the workspace name was. I do know the SYSTEM user password. ...
2
votes
1answer
764 views

ORA-12899: importing a .dmp file + character set conversion

I'm working on a django project on Ubuntu 10.04 with Oracle Database Server , so I've installed: Oracle Database 10g xe universal Rel.10.2.0.1.0 cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64 When I ...
0
votes
1answer
407 views

Error during the installation of oracle 11gxe

When I tried to install Oracle 11g XE into my machine (Windows XP media center edition, version 2002 SP3) I'm getting an error as 0x80040702 Description: Failed to load DLL:chkportDll2 I've ...
1
vote
1answer
417 views

Oracle XE 11.2 Export / Import Charset

I created a database in oracle XE 11.2 that uses charset AL32UTF8 that I now want to export. When I perform the export, the resulting data appears in WE8MSWIN1252 character set and AL16UTF16 NCHAR ...
5
votes
3answers
4k views

Cannot drop nonexistent constraint and cannot create it either

While testing some migration scripts with a copy of production data (scripts run fine with development data) I found a curious situation. A CONSTRAINT has changed so I'm issuing DROP + ADD commands: ...