5 Answered Questions for the topic oracle dba

07/01/19

ORA-24756: transaction does not exist?
Am doing a distributed update and I get this ORA-24756 error: DISTRIB TRAN bea1.67AA54355C4A74ECDEE0 is local tran 6.42.332492 (hex=06.2a.512cc) insert pending prepared... more
Follows • 1
Expert Answers •1

06/25/19

Oracle DBA, Unique situation with ORA-01017: invalid username/password; logon denied?
I am facing a very unique situation here in Oracle DB. I am facing "ORA-01017: invalid username/password; logon denied" error while logging in to my Oracle user using sqlplus. Basic information... more
Follows • 1
Expert Answers •1

06/25/19

Oracle - exchange partitions with a table?
I try to create a table2 on Oracle 11g.2.0.3 with: CREATE table2 LOGGING TABLESPACE TS_table1_2014 PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS... more
Follows • 1
Expert Answers •1

06/25/19

Oracle DB: delete all the contents?
I have oracle DB it is for testing purpose, I have not added any tables. I just want clear all the files like control, redo, archive, date. Ultimately I want fresh db. I know it can done by delete... more
Follows • 1
Expert Answers •1

06/24/19

Migrate / Copy Huge data from Oracle to SQL Server?
I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.