All Questions
Tagged with export oracle-12c
7 questions
0
votes
1
answer
7k
views
Oracle 12c to 19c Internal Schema Export & Import
I want to exp & imp operations for APEX users from Oracle Database 12cR1 to 19c.
Data Pump Utility can't do that. When I try to export by using following parfile and command:
DUMPFILE=APEX.dmp
...
- 29
1
vote
1
answer
604
views
EXPDP - why is block estimate significantly larger than segment size?
I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB
SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME';
MB
----------
...
- 137
0
votes
0
answers
801
views
Export DataPump - ORA-01555 Snapshot too old
I'm trying to export a customer's production database (schema) for problem solving.
During export, I'm getting the following:
Estimate in progress using BLOCKS method...
Processing object type ...
- 137
1
vote
2
answers
7k
views
How to export user with tables and tablespace oracle
I'm a newbie to Oracle World.
I have to export, from computer A, tables and their data, to computer B.
So, my question is: is there a way to export user, tablespace, tables and their data with one ...
- 111
2
votes
1
answer
8k
views
Oracle 12c export and import schema with different data tablespace and index tablespace
Suppose that I exported the schema objects from my Oracle 12c database using the original export utility as below:
exp userid=<export_schema_name>/<export_schema_password>@<db_string&...
2
votes
2
answers
4k
views
No tables found after running Expdp and Impdp in Oracle 12c
I am trying to export a schema which only contains one table with one row on it. It has a table called "product" and resides in a tablespace called "tbs_data". Here's the expdp command I ran which ...
- 21
0
votes
2
answers
2k
views
Unique constraint error Oracle
I have two databases - one is 11g and another 12c. 12c db has the exact data of 11g (expdp/impdp). Now I'm facing an error in one of the tables with unique constraint error. I have checked the ...
- 1,926