Import – Exports an entire Oracle database to another computer

I have an Oracle 11g database on a machine from which I want to export tables and data to another computer running 18c. I want to export a complete set of tables, triggers, and the data stored in it for a given user. I found several ideas on the Internet – with SQL Developer, Data Pump, etc.

What is the easiest way to do this? I have never exported or imported a database and find myself lost in all the information and so on.

Data replication from Oracle 12c to MySQL with Golden Gate – is this possible?

I tried to replicate the tables with the regular method "extract / replicate" and got the error message "Classic Extract does not support multi-client container databases" in Oracle 12c (source DB). That said, I could only use the built-in method to accomplish this.

However, after setting up Integrated Extract on Oracle 12c, MySql Golden Gate does not seem to know about the integrated replication method, but only about the classic one.

Does anyone have experience replicating data between the two? I will be glad about your feedback.

Many Thanks.

Database – What is Oracle GBO SIGOM and how does the licensing work?

Thank you for your contribution to Stack Overflow in Portuguese!

  • Make sure you answer the question, Enter details about your solution and share your findings.

But avoid

  • Ask for explanations or details of other answers.
  • Make statements based solely on your opinion; Point references or previous experience.

For more information, see our tips for writing good answers.

oracle – Debugging and updating values ​​in the APEX Interactive report

I have two issues in my application Interactive Report APEX 4.2.5. I have seen some examples of this functionality, but they have not helped me yet.

1 – In the SELECT statement of the report, some fields are selected with apex_item.text so that the user can update these fields. This part works well. My problem is writing back the updated values ​​to a table (SELECT is in a view). I have a SQL Autonomous Block process that should do this (loop through the rows and access values ​​with APEX_APPLICATION.G_Fxx), but it will not work. After sending, no errors are returned. Instead, the values ​​are reset to their original values. How can I save these updates in the table?

2 – Within the SQL process I have activated and added some APEX_DEBUG.MESSAGE statements, but I can not see the result of these statements anywhere in the debug log or in the table. How can I see the result of these debug commands?

Here is the SELECT:

Choose REQUISITION_LINE_ID
, apex_item.hidden (50, REQUISITION_LINE_ID, 10,10) rid
, REQ_NUMBER
, REQ_LINE_NUMBER
, REQUISITION_QUANTITY
, SO_NUMBER
SO_LINE
,ORDERED QUANTITY
, SKU
,DESCRIPTION
apex_item.text (10, SUPPLY_PO_NUMBER, 10, 10) SUPPLY_PO_NUMBER
apex_item.text (20, SUPPLY_PO_LINE, 10, 10) SUPPLY_PO_LINE
, apex_item.text (30, SUPPLY_PO_SHIPMENT, 10, 10) SUPPLY_PO_SHIPMENT
from camlb.xxcb_requisition_reference;

And here is the SQL process:

to explain
ID number;
Order number;
Poli number;
Tracking number;

begin
APEX_DEBUG.ENABLE (p_level => 9);

for i in 1..APEX_APPLICATION.G_F50.count
loop

id: = APEX_APPLICATION.G_F50 (i);
poorder: = APEX_APPLICATION.G_F10 (i);
poline: = APEX_APPLICATION.G_F20 (i);
poshipment: = APEX_APPLICATION.G_F30 (i);

APEX_DEBUG_MESSAGE.LOG_MESSAGE (& # 39; ID is & # 39; || id || & # 39 ;, PO is & # 39 ;| poorder || & # 39 ;, SUPPLY_PO_LINE is & # 39; s & nbsp; poline || & # 39 ;, SUPPLY_PO_SHIPMENT is & # 39;; poshipment);
APEX_DEBUG.MESSAGE (ID ID is # || id ||,, PO is | || poorder ||,, SUPPLY_PO_LINE is pol || poline || & # 39 ;, SUPPLY_PO_SHIPMENT is & # 39;; poshipment);

update APPS.po_requisition_lines_all
set ATTRIBUTE1 = poorder,
ATTRIBUTE2 = poline,
ATTRIBUTE3 = shipping
where requisition_line_id = id;

end loop;
The End;

Database Tomcat / Oracle queries display updated information only in indexed columns

I apologize if this seems trivial, but I just can not find an answer to this problem. I have a Java web application on a Tomcat server configured with Oracle Database 12c in the context of the web application (JNDI). No special framework is used (ie Spring), but only everything that is contained in the packages java.sql and javax.sql.

When data in indexed columns is changed in the web application, the changes are reflected in the web application when the queries are run again. If the change is made to a column that is not indexed, the change does not appear (but the data changes if you check the table directly or restart Tomcat). The queries are just simple update queries, nothing complicated.

I think it has something to do with how Tomcat shares the sessions. When you restart the Tomcat server (Stop / Start), the changes are displayed.

Here is the context configuration (only the resource part):


I've read information about statement caches, but I'm not sure if the instruction cache would be the problem, only the results appeared to be cached and not refreshed on re-queries (unless the instruction caches store this information , I thought I was only for the queries themselves and not the result sets). Is there a way to force the database connection to not use old results with Oracle?

Any help is grateful, thanks.

Oracle – Why does SQL Plus consider a larger number than smaller?

Their quantity columns are not stored as numbers but as strings, which can be B. causes that 10 to be "smaller" than 9 – A string comparison is obviously based on the characters in the string, not integers, so the result you see.

Oracle does not convert the values ​​to numbers when you make a comparison (& # 39;<' and '>& # 39; in your case), but it implicitly converts them into numbers when you perform mathematical operations on them, hence the - works as expected.

If you occupation the VARCHAR Columns to a NUMBER When you make the comparison, your query works correctly:

choose *
from orders
where TO_NUMBER (quantity) <TO_NUMBER (quantity);

However, it is better to recreate your table with the correct data types.

An example of DB Fiddle to demonstrate it all can be found here.

The ability to automate and schedule an SQL query output to a CSV file with a timestamp in Oracle SQL Developer

Is it possible to automate and schedule an SQL query output to a CSV file with a timestamp in Oracle SQL Developer?

CHOOSE
*
FROM
bag_summaries
FROM WHERE
register_tt between trunc (SYSDATE – 1, # ddd & # 39;) and trunc (SYSDATE, & ddd & # 39;
SORT BY
I would;

Import Oracle Unicode data with OLE DB source and destination into SSIS 2015

My problem is identical to this post on mssqltips.com, but my problem is imported from Oracle, not from Excel.

I come all the way down to where I have to map the output columns from my data conversion to the target. I have assigned these columns, but still get the error in my source task.

I also tried almost every answer to this similar thread without success.

How can I migrate this table with SSIS from Oracle to SQL Server?