Viewing 15 posts - 2,356 through 2,370 (of 3,061 total)
Provided FTP performs well and the issue is not related to CNS(*) Paul's idea would do the trick, here is the Oracle side magic to get a csv file...
log into...
September 9, 2009 at 6:56 am
Paul White (9/8/2009)
Thanks for posting such a super-helpful and detailed reply though - well done sir.
Just to make it clear, rownum does not exist in real world, it's a pseudo-column....
September 8, 2009 at 8:29 pm
Paul White (9/8/2009)
If ROWNUM in Oracle returns rows ordered by the internal row identifier
...actually, it doesn't.
September 8, 2009 at 6:02 pm
tgarland (8/31/2009)
I am looking at multi-tenant because I am going to have multiple companies accessing the database and only their information along with the global tables.
Just out of...
September 8, 2009 at 4:41 pm
bitbucket (9/7/2009)
CREATE PROCEDURE my_Proc_Name;1
AS
SELECT some column from some table
GO
CREATE PROCEDURE my_Proc_Name;2
AS
SELECT some other...
September 8, 2009 at 4:38 pm
newbieuser (9/8/2009)
I do 'select rownum from table' in oracle to select rows ordered by rownum.
:w00t: No, you don't.
In the Oracle world rownum is a pseudo-column, Oracle assigns -to rownum- a...
September 8, 2009 at 4:31 pm
Since system databases cannot be moved I don't see this happening.
When going for solution suggested in previous post please be aware a system database can only be restored in a...
September 7, 2009 at 4:16 pm
Silverfox (9/7/2009)
if you are serious about learning, I would suggest you get a cheap laptop or netbook and do it that way.
I second this motion.
The alternative is for you to...
September 7, 2009 at 4:03 pm
jymoorthy (9/7/2009)
September 7, 2009 at 3:59 pm
John Rowan (9/2/2009)
September 7, 2009 at 3:55 pm
Why is SQL Server part of this picture?
The most efficient way would be for Oracle side to pull data from AS400 in a single step.
September 7, 2009 at 3:51 pm
liuc (9/2/2009)
Which is the "best practice" in these cases?
Put "Design" as step #1 of project life cycle, not as last step.
September 7, 2009 at 3:42 pm
michael.welcome (5/9/2008)
This is not a joke.
I have my doubts this was not a joke.
September 7, 2009 at 3:37 pm
lallen (9/3/2009)
I ran a simple query (select count(*) from table), and the query took over 8...
September 7, 2009 at 3:32 pm
Viewing 15 posts - 2,356 through 2,370 (of 3,061 total)