E9.1 SQL to Copy From PRODDTA to TESTDTA

[FrankCLT]

Hi All,

I'm needing a fresh copy of data from Production to TEST for a single table. Not sure how to cross data sources....any assistance would be greatly appreciated.

Forgot to mention that I'm using Oracle SQL Developer tool.

Thank you,
FrankCLT

 

[MFreitag]

If your databases are on the same machine you could do something like this:

TRUNCATE TABLE TESTDTA.TABLE;
INSERT INTO TESTDTA.TABLE SELECT * FROM PRODDTA.TABLE;

This is of course based on the fact that you're not giving a lot of information (=none). If the table is quite big for example, i'd go a different route.

 

[brother_of_karamazov]

Hi All,

I'm needing a fresh copy of data from Production to TEST for a single table. Not sure how to cross data sources....any assistance would be greatly appreciated.

Forgot to mention that I'm using Oracle SQL Developer tool.

Thank you,
FrankCLT

E1: ENV: How To Use UBE R98403, R98403A, R98403B, R98403E, R98403G To Copy Data From One Pathcode to Another Pathcode (Doc ID 626170.1)

https://support.oracle.com/epmos/faces/DocContentDisplay?id=626170.1

 

[CHo]

E1: ENV: How To Use UBE R98403, R98403A, R98403B, R98403E, R98403G To Copy Data From One Pathcode to Another Pathcode (Doc ID 626170.1)

https://support.oracle.com/epmos/faces/DocContentDisplay?id=626170.1

It depends on if Frank has access to these UBE or not. If not, then use the SQL statements. Developers usually don't have access to these UBE.

 

[alfredorz]

Hi All,

I'm needing a fresh copy of data from Production to TEST for a single table. Not sure how to cross data sources....any assistance would be greatly appreciated.

Forgot to mention that I'm using Oracle SQL Developer tool.

Thank you,
FrankCLT

Do you not access to fat client? it very easy copy and quick data from enviroments with table operations.

Other way, as say @MFreitag if is the same machine and has permissions between schemas you can doing these operations.

As alternative, depends number of rows, you can select all records table (or you can need), export as insert, copy and paste in TEST and launch script. You can export to excel and import from excel too.