Reputation
635
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 15 30
Impact
~189k people reached

  • 0 posts edited
  • 1 helpful flag
  • 54 votes cast
Jan
12
comment Turn on multi-threading in Oracle for ETL purposes
That's the answer then!
Jan
11
revised Turn on multi-threading in Oracle for ETL purposes
added 71 characters in body
Jan
11
comment Turn on multi-threading in Oracle for ETL purposes
I have no CLUE what they mean by "query portions of DML statements" ... in the link above. Maybe someone is the wiser for a potential answer here.
Jan
11
comment Turn on multi-threading in Oracle for ETL purposes
"Enable Parallel DML" is the section in the link below... Looks like in the SQL session, we just need to call "ENABLE PARALLEL DML", since INSERT statements are being done via ETL. And it looks like we need to enable some attribute on the table to enable it. docs.oracle.com/cd/B28359_01/server.111/b28313/…
Jan
11
asked Turn on multi-threading in Oracle for ETL purposes
Jan
11
revised Significance of “.WORLD” on end of Oracle connection
edited tags
Jan
11
accepted Significance of “.WORLD” on end of Oracle connection
Jan
11
comment Significance of “.WORLD” on end of Oracle connection
Looks like the .WORLD isn't needed at all if that names.default_domain isn't set. In order to get the client working, just make sure the tnsnames.ora file on the server (in the network/admin folder) matches the tnsnames.ora file on the client (in the client network/admin folder).
Dec
31
awarded  Notable Question
Dec
29
asked Significance of “.WORLD” on end of Oracle connection
Dec
23
revised List of escape sequences for Postgresql string data types
added 99 characters in body
Dec
23
revised List of escape sequences for Postgresql string data types
added 99 characters in body
Dec
15
comment List of escape sequences for Postgresql string data types
well, some imports for us are done via copy command (our automated ones), and some are done via phpMyAdmin site (yes for postgresql) using the import option
Dec
15
comment List of escape sequences for Postgresql string data types
I'm looking for others as well... \n, \t, new line characters in data, etc...
Dec
15
asked List of escape sequences for Postgresql string data types
Dec
3
awarded  Famous Question
Dec
2
accepted Differences between the different installers of SQL Server 2014 Express
Dec
2
asked Differences between the different installers of SQL Server 2014 Express
Nov
21
awarded  Yearling
Oct
21
awarded  Quorum