Rename the Oracle 10g database user

Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

S1989082060 pointsBadges:

Can I clone a user in the same Oracle database?

I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

ITKE1,067,975 pointsBadges:

How do I solve the ORA-00933: SQL command not properly ended error message?

For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

ITKE1,067,975 pointsBadges:

How to create multiple Oracle 11g databases

Our department is currently using Oracle 11g and all of us are using it (including developers). But here's the issue - we can't buy several different licenses for each person. Would I be able to create one specific data for each person?

ITKE1,067,975 pointsBadges:

Setting Oracle database to auto-commit

Is there a way for me to find out if my Oracle database is set to auto-commit? If it is, how can I turn that off too? Thanks!

ITKE1,067,975 pointsBadges:

Cannot connect to Oracle database: Oranos.dll is missing from my computer

I've been trying to connect to my Oracle database but when this code is running (con = new OracleConnection(oradb);), it keeps giving me this error message: The program can't start because oraons.dll is missing from your computer. Try reinstalling the program to fix this problem. What should I do?...

ITKE1,067,975 pointsBadges:

Deleting millions of records in Oracle database

My Oracle database has roughly 2 billion (yes, I said billion) records. But we noticed that over 10 million of them are duplicates. How can we go about deleting those? Thanks!

ITKE1,067,975 pointsBadges:

Getting all sequences in Oracle database

Hi experts! Would there be an Oracle command I could run so I could get all of the sequences in my Oracle database? This is for Oracle 11g / Oracle Toad. Should I use the command line?

ITKE1,067,975 pointsBadges:

Manual uninstall of Oracle

For some reason (this only happens once in a while) but my Oracle database on Windows disappears. Because of this - I'm thinking of doing a manual uninstall. How can I do that?

ITKE1,067,975 pointsBadges:

Insert table into existing Oracle column

I noticed that whenever I try to add an existing to an existing column in Oracle, it's always down at the end of the table. Is there an Oracle command where I can tell it to put it in the table? Thank you.

ITKE1,067,975 pointsBadges:

I would like to take a backup of Oracle Database by using unix scripts

I would like to take a backup of Oracle Database by using Unix scripts. Is it possible? If yes, please provide the details.

shamcpt5 pointsBadges:

Oracle Certification?

Hi, I want to know, the total procedure for Oracle data base certification. Thanks

Amin4rmOvexTechnology250 pointsBadges:

Connect remote Oracle database through PL/SQL Developer

We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

ITKE1,067,975 pointsBadges:

Finding size of Oracle database

We have a database in Oracle that we need to figure out the exact size of (it's currently on our disk). How can we do that? Is there a certain Oracle command? Thanks!

ITKE1,067,975 pointsBadges:

Display all views in Oracle database

On an Oracle database, can I display all the views that are currently set? Can I do this through SQL Developer?

ITKE1,067,975 pointsBadges:

Connect Oracle database from Microsoft Excel application

Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

ITKE1,067,975 pointsBadges:

Create first database in Oracle Database 11g Express

Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

ITKE1,067,975 pointsBadges:

Oracle Database 12C on Ubuntu

Does anyone know how I can install Oracle Database 12c on Ubuntu? I tried but I keep getting errors during the linking phase. Thanks for any help.

ITKE1,067,975 pointsBadges:

Name of server my Oracle database is hosted on

I'm in desperate need here for some help: How can I find the name of the actually server my Oracle database is hosted on? Thank you so much!!

ITKE1,067,975 pointsBadges:

Confirm what version the Oracle Database is in SQL

My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

ITKE1,067,975 pointsBadges: